{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","STOCK POINT PRICE"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":2,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":65,"n_cols":36,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,0,0,25],[1,0,1,25],[2,0,2,25],[3,0,3,25],[4,0,4,25],[5,0,5,25],[7,31,7,35],[7,1,7,5],[7,6,7,10],[7,11,7,15],[7,16,7,20],[7,21,7,25],[7,26,7,30]]}
["UNITED BROTHERS"]
["CONSIGNMENT STOCKIST OF GAIL (INDIA) LTD"]
["301,HERITAGE PLAZA, R.S.MAHARAJ MARG,( TELI GALLI CROSS LANE), ANDHERI (E), MUMBAI - 400 069"]
[" TEL:  26844612(4 LINES) FAX: 26822914  E-MAIL:,info@unibrothers.com , prashant@unibrothers.com , jyoti@unibrothers.com"]
["EX-WORKS PRICE OF HDPE \"G-LEX / G-LENE \" W.E.F. 1ST  MAY 2014"]
[]
[null,"Freight",null,2048.77,null,null,"Freight",null,2061.17,null,null,"Freight",null,2537.23,null,null,"Freight",null,1959.23,null,null,"Freight",null,1624.98,null,null,"Freight",null,2247.23,null,null,"           Freight  3069.18"]
[null,"DAMAN",null,null,null,null,"SILVASSA",null,null,null,null,"MUMBAI/BHIWANDI/THANE",null,null,null,null,"JALGAON",null,null,null,null,"NAGPUR",null,null,null,null,"AURANGABAD",null,null,null,null,"SANGLI"]
[null,"BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS"]
["BM"]
["B52A003A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A11,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":106400},1000,0,{"$f":"(B11-C11-D11)*12.36%","v":13027.439999999999},{"$f":"B11-C11-D11+E11","v":118427.44},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A11,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":106400},1000,0,{"$f":"(G11-H11-I11)*12.36%","v":13027.439999999999},{"$f":"G11-H11-I11+J11","v":118427.44},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A11,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":105760},1000,0,{"$f":"(L11-M11-N11)*12.36%","v":12948.335999999999},{"$f":"L11-M11-N11+O11","v":117708.336},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A11,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":106790},1000,0,{"$f":"(Q11-R11-S11)*12.36%","v":13075.643999999998},{"$f":"Q11-R11-S11+T11","v":118865.644},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A11,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":107840},1000,0,{"$f":"(V11-W11-X11)*12.36%","v":13205.423999999999},{"$f":"V11-W11-X11+Y11","v":120045.424},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A11,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":106410},1000,0,{"$f":"(AA11-AB11-AC11)*12.36%","v":13028.675999999999},{"$f":"AA11-AB11-AC11+AD11","v":118438.67600000001},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A11,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":105780},1000,0,{"$f":"(AF11-AG11-AH11)*12.36%","v":12950.807999999999},{"$f":"AF11-AG11-AH11+AI11","v":117730.808}]
["B63A003A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A12,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":106400},1000,0,{"$f":"(B12-C12-D12)*12.36%","v":13027.439999999999},{"$f":"B12-C12-D12+E12","v":118427.44},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A12,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":106400},1000,0,{"$f":"(G12-H12-I12)*12.36%","v":13027.439999999999},{"$f":"G12-H12-I12+J12","v":118427.44},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A12,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":105760},1000,0,{"$f":"(L12-M12-N12)*12.36%","v":12948.335999999999},{"$f":"L12-M12-N12+O12","v":117708.336},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A12,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":106790},1000,0,{"$f":"(Q12-R12-S12)*12.36%","v":13075.643999999998},{"$f":"Q12-R12-S12+T12","v":118865.644},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A12,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":107840},1000,0,{"$f":"(V12-W12-X12)*12.36%","v":13205.423999999999},{"$f":"V12-W12-X12+Y12","v":120045.424},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A12,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":106410},1000,0,{"$f":"(AA12-AB12-AC12)*12.36%","v":13028.675999999999},{"$f":"AA12-AB12-AC12+AD12","v":118438.67600000001},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A12,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":105780},1000,0,{"$f":"(AF12-AG12-AH12)*12.36%","v":12950.807999999999},{"$f":"AF12-AG12-AH12+AI12","v":117730.808}]
["B55HM0003A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A13,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":110350},1000,0,{"$f":"(B13-C13-D13)*12.36%","v":13515.659999999998},{"$f":"B13-C13-D13+E13","v":122865.66},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A13,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":110360},1000,0,{"$f":"(G13-H13-I13)*12.36%","v":13516.895999999999},{"$f":"G13-H13-I13+J13","v":122876.89599999999},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A13,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":109770},1000,0,{"$f":"(L13-M13-N13)*12.36%","v":13443.971999999998},{"$f":"L13-M13-N13+O13","v":122213.97199999999},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A13,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":110800},1000,0,{"$f":"(Q13-R13-S13)*12.36%","v":13571.279999999999},{"$f":"Q13-R13-S13+T13","v":123371.28},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A13,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":111940},1000,0,{"$f":"(V13-W13-X13)*12.36%","v":13712.183999999999},{"$f":"V13-W13-X13+Y13","v":124652.18399999999},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A13,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":110410},1000,0,{"$f":"(AA13-AB13-AC13)*12.36%","v":13523.075999999999},{"$f":"AA13-AB13-AC13+AD13","v":122933.076},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A13,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":109890},1000,0,{"$f":"(AF13-AG13-AH13)*12.36%","v":13458.803999999998},{"$f":"AF13-AG13-AH13+AI13","v":122348.804}]
["B53EA0035A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A14,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":106900},1000,0,{"$f":"(B14-C14-D14)*12.36%","v":13089.239999999998},{"$f":"B14-C14-D14+E14","v":118989.23999999999},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A14,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":106900},1000,0,{"$f":"(G14-H14-I14)*12.36%","v":13089.239999999998},{"$f":"G14-H14-I14+J14","v":118989.23999999999}]
["CABLE-INSUL"]
["C43D006A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A16,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":103905},1000,0,{"$f":"(B16-C16-D16)*12.36%","v":12719.057999999999},{"$f":"B16-C16-D16+E16","v":115624.058},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A16,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":103905},1000,0,{"$f":"(G16-H16-I16)*12.36%","v":12719.057999999999},{"$f":"G16-H16-I16+J16","v":115624.058},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A16,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":103287.5},1000,0,{"$f":"(L16-M16-N16)*12.36%","v":12642.734999999999},{"$f":"L16-M16-N16+O16","v":114930.235},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A16,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":104323},1000,0,{"$f":"(Q16-R16-S16)*12.36%","v":12770.7228},{"$f":"Q16-R16-S16+T16","v":116093.7228},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A16,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":105415.5},1000,0,{"$f":"(V16-W16-X16)*12.36%","v":12905.755799999999},{"$f":"V16-W16-X16+Y16","v":117321.2558},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A16,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":103971.5},1000,0,{"$f":"(AA16-AB16-AC16)*12.36%","v":12727.277399999999},{"$f":"AA16-AB16-AC16+AD16","v":115698.77739999999},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A16,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":103363.5},1000,0,{"$f":"(AF16-AG16-AH16)*12.36%","v":12652.128599999998},{"$f":"AF16-AG16-AH16+AI16","v":115015.6286}]
[]
["SHETG"]
["E45A003A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A19,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":104950},1000,0,{"$f":"(B19-C19-D19)*12.36%","v":12848.22},{"$f":"B19-C19-D19+E19","v":116798.22},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A19,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":104950},1000,0,{"$f":"(G19-H19-I19)*12.36%","v":12848.22},{"$f":"G19-H19-I19+J19","v":116798.22},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A19,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":104290},1000,0,{"$f":"(L19-M19-N19)*12.36%","v":12766.643999999998},{"$f":"L19-M19-N19+O19","v":116056.644},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A19,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":105390},1000,0,{"$f":"(Q19-R19-S19)*12.36%","v":12902.603999999999},{"$f":"Q19-R19-S19+T19","v":117292.60399999999},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A19,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":106530},1000,0,{"$f":"(V19-W19-X19)*12.36%","v":13043.507999999998},{"$f":"V19-W19-X19+Y19","v":118573.508},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A19,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":105020},1000,0,{"$f":"(AA19-AB19-AC19)*12.36%","v":12856.871999999999},{"$f":"AA19-AB19-AC19+AD19","v":116876.872},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A19,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":104380},1000,0,{"$f":"(AF19-AG19-AH19)*12.36%","v":12777.767999999998},{"$f":"AF19-AG19-AH19+AI19","v":116157.768}]
["E45A003OG"]
["EXTR "]
["E52A003A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A22,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":107620},1000,0,{"$f":"(B22-C22-D22)*12.36%","v":13178.231999999998},{"$f":"B22-C22-D22+E22","v":119798.232},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A22,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":107620},1000,0,{"$f":"(G22-H22-I22)*12.36%","v":13178.231999999998},{"$f":"G22-H22-I22+J22","v":119798.232},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A22,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":106960},1000,0,{"$f":"(L22-M22-N22)*12.36%","v":13096.655999999999},{"$f":"L22-M22-N22+O22","v":119056.656},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A22,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":108060},1000,0,{"$f":"(Q22-R22-S22)*12.36%","v":13232.615999999998},{"$f":"Q22-R22-S22+T22","v":120292.61599999999},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A22,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":109200},1000,0,{"$f":"(V22-W22-X22)*12.36%","v":13373.519999999999},{"$f":"V22-W22-X22+Y22","v":121573.52},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A22,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":107680},1000,0,{"$f":"(AA22-AB22-AC22)*12.36%","v":13185.647999999999},{"$f":"AA22-AB22-AC22+AD22","v":119865.648},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A22,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":107050},1000,0,{"$f":"(AF22-AG22-AH22)*12.36%","v":13107.779999999999},{"$f":"AF22-AG22-AH22+AI22","v":119157.78}]
["E52A003OG"]
["E52U003A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A24,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":111400},1000,0,{"$f":"(B24-C24-D24)*12.36%","v":13645.439999999999},{"$f":"B24-C24-D24+E24","v":124045.44},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A24,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":111400},1000,0,{"$f":"(G24-H24-I24)*12.36%","v":13645.439999999999},{"$f":"G24-H24-I24+J24","v":124045.44},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A24,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":110740},1000,0,{"$f":"(L24-M24-N24)*12.36%","v":13563.863999999998},{"$f":"L24-M24-N24+O24","v":123303.864},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A24,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":111840},1000,0,{"$f":"(Q24-R24-S24)*12.36%","v":13699.823999999999},{"$f":"Q24-R24-S24+T24","v":124539.82399999999},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A24,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":112980},1000,0,{"$f":"(V24-W24-X24)*12.36%","v":13840.727999999999},{"$f":"V24-W24-X24+Y24","v":125820.728},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A24,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":111460},1000,0,{"$f":"(AA24-AB24-AC24)*12.36%","v":13652.855999999998},{"$f":"AA24-AB24-AC24+AD24","v":124112.856},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A24,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":110830},1000,0,{"$f":"(AF24-AG24-AH24)*12.36%","v":13574.987999999999},{"$f":"AF24-AG24-AH24+AI24","v":123404.988}]
["E52U003OG"]
["HM FILM"]
["F55HM0003A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A27,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":105400},1000,0,{"$f":"(B27-C27-D27)*12.36%","v":12903.839999999998},{"$f":"B27-C27-D27+E27","v":117303.84},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A27,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":105910},1000,0,{"$f":"(G27-H27-I27)*12.36%","v":12966.875999999998},{"$f":"G27-H27-I27+J27","v":117876.876},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A27,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":105320},1000,0,{"$f":"(L27-M27-N27)*12.36%","v":12893.951999999999},{"$f":"L27-M27-N27+O27","v":117213.952},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A27,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":106350},1000,0,{"$f":"(Q27-R27-S27)*12.36%","v":13021.259999999998},{"$f":"Q27-R27-S27+T27","v":118371.26},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A27,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":107490},1000,0,{"$f":"(V27-W27-X27)*12.36%","v":13162.163999999999},{"$f":"V27-W27-X27+Y27","v":119652.164},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A27,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":105960},1000,0,{"$f":"(AA27-AB27-AC27)*12.36%","v":12973.055999999999},{"$f":"AA27-AB27-AC27+AD27","v":117933.056},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A27,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":105440},1000,0,{"$f":"(AF27-AG27-AH27)*12.36%","v":12908.783999999998},{"$f":"AF27-AG27-AH27+AI27","v":117348.784}]
["F55HM0003OG"]
["IM HIGH"]
["I50A180A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A30,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":102220},1000,0,{"$f":"(B30-C30-D30)*12.36%","v":12510.791999999999},{"$f":"B30-C30-D30+E30","v":113730.792},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A30,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":102230},1000,0,{"$f":"(G30-H30-I30)*12.36%","v":12512.027999999998},{"$f":"G30-H30-I30+J30","v":113742.02799999999},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A30,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":101700},1000,0,{"$f":"(L30-M30-N30)*12.36%","v":12446.519999999999},{"$f":"L30-M30-N30+O30","v":113146.52},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A30,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":102660},1000,0,{"$f":"(Q30-R30-S30)*12.36%","v":12565.175999999999},{"$f":"Q30-R30-S30+T30","v":114225.17600000001},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A30,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":103770},1000,0,{"$f":"(V30-W30-X30)*12.36%","v":12702.371999999999},{"$f":"V30-W30-X30+Y30","v":115472.372},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A30,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":102300},1000,0,{"$f":"(AA30-AB30-AC30)*12.36%","v":12520.679999999998},{"$f":"AA30-AB30-AC30+AD30","v":113820.68},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A30,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":101840},1000,0,{"$f":"(AF30-AG30-AH30)*12.36%","v":12463.823999999999},{"$f":"AF30-AG30-AH30+AI30","v":113303.82399999999}]
["I50A180OG"]
["IM LOW"]
["I60A080A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A33,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":103590},1000,0,{"$f":"(B33-C33-D33)*12.36%","v":12680.123999999998},{"$f":"B33-C33-D33+E33","v":115270.124},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A33,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":103590},1000,0,{"$f":"(G33-H33-I33)*12.36%","v":12680.123999999998},{"$f":"G33-H33-I33+J33","v":115270.124},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A33,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":102940},1000,0,{"$f":"(L33-M33-N33)*12.36%","v":12599.784},{"$f":"L33-M33-N33+O33","v":114539.784},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A33,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":104030},1000,0,{"$f":"(Q33-R33-S33)*12.36%","v":12734.507999999998},{"$f":"Q33-R33-S33+T33","v":115764.508},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A33,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":105180},1000,0,{"$f":"(V33-W33-X33)*12.36%","v":12876.647999999999},{"$f":"V33-W33-X33+Y33","v":117056.648},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A33,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":103660},1000,0,{"$f":"(AA33-AB33-AC33)*12.36%","v":12688.775999999998},{"$f":"AA33-AB33-AC33+AD33","v":115348.776},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A33,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":103020},1000,0,{"$f":"(AF33-AG33-AH33)*12.36%","v":12609.671999999999},{"$f":"AF33-AG33-AH33+AI33","v":114629.67199999999}]
["I60A080OG"]
["IM-L-UV"]
["I60U080A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A36,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":105130},1000,0,{"$f":"(B36-C36-D36)*12.36%","v":12870.467999999999},{"$f":"B36-C36-D36+E36","v":117000.46799999999},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A36,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":105130},1000,0,{"$f":"(G36-H36-I36)*12.36%","v":12870.467999999999},{"$f":"G36-H36-I36+J36","v":117000.46799999999},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A36,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":104470},1000,0,{"$f":"(L36-M36-N36)*12.36%","v":12788.891999999998},{"$f":"L36-M36-N36+O36","v":116258.89199999999},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A36,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":105570},1000,0,{"$f":"(Q36-R36-S36)*12.36%","v":12924.851999999999},{"$f":"Q36-R36-S36+T36","v":117494.852},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A36,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":106710},1000,0,{"$f":"(V36-W36-X36)*12.36%","v":13065.755999999999},{"$f":"V36-W36-X36+Y36","v":118775.75599999999},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A36,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":105200},1000,0,{"$f":"(AA36-AB36-AC36)*12.36%","v":12879.119999999999},{"$f":"AA36-AB36-AC36+AD36","v":117079.12},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A36,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":104560},1000,0,{"$f":"(AF36-AG36-AH36)*12.36%","v":12800.016},{"$f":"AF36-AG36-AH36+AI36","v":116360.016}]
["I60U080OG"]
["PIPE (PE80)"]
["P54A001A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A39,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":112610},1000,0,{"$f":"(B39-C39-D39)*12.36%","v":13794.995999999999},{"$f":"B39-C39-D39+E39","v":125404.996},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A39,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":112620},1000,0,{"$f":"(G39-H39-I39)*12.36%","v":13796.231999999998},{"$f":"G39-H39-I39+J39","v":125416.232},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A39,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":112030},1000,0,{"$f":"(L39-M39-N39)*12.36%","v":13723.307999999999},{"$f":"L39-M39-N39+O39","v":124753.308},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A39,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":113060},1000,0,{"$f":"(Q39-R39-S39)*12.36%","v":13850.615999999998},{"$f":"Q39-R39-S39+T39","v":125910.61599999999},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A39,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":114200},1000,0,{"$f":"(V39-W39-X39)*12.36%","v":13991.519999999999},{"$f":"V39-W39-X39+Y39","v":127191.52},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A39,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":112670},1000,0,{"$f":"(AA39-AB39-AC39)*12.36%","v":13802.411999999998},{"$f":"AA39-AB39-AC39+AD39","v":125472.412},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A39,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":112150},1000,0,{"$f":"(AF39-AG39-AH39)*12.36%","v":13738.14},{"$f":"AF39-AG39-AH39+AI39","v":124888.14}]
["PIPE (PE100)"]
["P52A003A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A41,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":114610},1000,0,{"$f":"(B41-C41-D41)*12.36%","v":14042.195999999998},{"$f":"B41-C41-D41+E41","v":127652.196},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A41,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":114620},1000,0,{"$f":"(G41-H41-I41)*12.36%","v":14043.431999999999},{"$f":"G41-H41-I41+J41","v":127663.432},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A41,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":114030},1000,0,{"$f":"(L41-M41-N41)*12.36%","v":13970.507999999998},{"$f":"L41-M41-N41+O41","v":127000.508},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A41,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":115060},1000,0,{"$f":"(Q41-R41-S41)*12.36%","v":14097.815999999999},{"$f":"Q41-R41-S41+T41","v":128157.81599999999},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A41,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":116200},1000,0,{"$f":"(V41-W41-X41)*12.36%","v":14238.72},{"$f":"V41-W41-X41+Y41","v":129438.72},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A41,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":114670},1000,0,{"$f":"(AA41-AB41-AC41)*12.36%","v":14049.611999999999},{"$f":"AA41-AB41-AC41+AD41","v":127719.61199999999},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A41,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":114150},1000,0,{"$f":"(AF41-AG41-AC41)*12.36%","v":13985.339999999998},{"$f":"AF41-AG41-AC41+AI41","v":127135.34}]
["RAFFIA"]
["W50A009A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A43,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":106720},1000,0,{"$f":"(B43-C43-D43)*12.36%","v":13066.991999999998},{"$f":"B43-C43-D43+E43","v":118786.992},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A43,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":106720},1000,0,{"$f":"(G43-H43-I43)*12.36%","v":13066.991999999998},{"$f":"G43-H43-I43+J43","v":118786.992},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A43,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":106060},1000,0,{"$f":"(L43-M43-N43)*12.36%","v":12985.415999999999},{"$f":"L43-M43-N43+O43","v":118045.416},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A43,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":107160},1000,0,{"$f":"(Q43-R43-S43)*12.36%","v":13121.375999999998},{"$f":"IF(S$8=\"NAGPUR\",HLOOKUP($A43,[1]Sheet6!$D$2:$AE$90,7,0))","v":false},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A43,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":108300},1000,0,{"$f":"(V43-W43-X43)*12.36%","v":13262.279999999999},{"$f":"V43-W43-X43+Y43","v":120562.28},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A43,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":106790},1000,0,{"$f":"(AA43-AB43-AC43)*12.36%","v":13075.643999999998},{"$f":"AA43-AB43-AC43+AD43","v":118865.644},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A43,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":106150},1000,0,{"$f":"(AF43-AG43-AH43)*12.36%","v":12996.539999999999},{"$f":"AF43-AG43-AH43+AI43","v":118146.54}]
["T50A010A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A44,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":106720},1000,0,{"$f":"(B44-C44-D44)*12.36%","v":13066.991999999998},{"$f":"B44-C44-D44+E44","v":118786.992},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A44,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":106720},1000,0,{"$f":"(G44-H44-I44)*12.36%","v":13066.991999999998},{"$f":"G44-H44-I44+J44","v":118786.992},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A44,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":106060},1000,0,{"$f":"(L44-M44-N44)*12.36%","v":12985.415999999999},{"$f":"L44-M44-N44+O44","v":118045.416},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A44,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":107160},1000,0,{"$f":"(Q44-R44-S44)*12.36%","v":13121.375999999998},{"$f":"Q44-R44-S44+T44","v":119281.376},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A44,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":108300},1000,0,{"$f":"(V44-W44-X44)*12.36%","v":13262.279999999999},{"$f":"V44-W44-X44+Y44","v":120562.28},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A44,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":106790},1000,0,{"$f":"(AA44-AB44-AC44)*12.36%","v":13075.643999999998},{"$f":"AA44-AB44-AC44+AD44","v":118865.644},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A44,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":106150},1000,0,{"$f":"(AF44-AG44-AH44)*12.36%","v":12996.539999999999},{"$f":"AF44-AG44-AH44+AI44","v":118146.54}]
["MF"]
["W52A009A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A46,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":103220},1000,0,{"$f":"(B46-C46-D46)*12.36%","v":12634.391999999998},{"$f":"B46-C46-D46+E46","v":114854.39199999999},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A46,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":103220},1000,0,{"$f":"(G46-H46-I46)*12.36%","v":12634.391999999998},{"$f":"G46-H46-I46+J46","v":114854.39199999999},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A46,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":102560},1000,0,{"$f":"(L46-M46-N46)*12.36%","v":12552.815999999999},{"$f":"L46-M46-N46+O46","v":114112.81599999999},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A46,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":103660},1000,0,{"$f":"(Q46-R46-S46)*12.36%","v":12688.775999999998},{"$f":"Q46-R46-S46+T46","v":115348.776},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A46,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":104800},1000,0,{"$f":"(V46-W46-X46)*12.36%","v":12829.679999999998},{"$f":"V46-W46-X48+Y46","v":116629.68},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A46,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":103290},1000,0,{"$f":"(AA46-AB46-AC46)*12.36%","v":12643.043999999998},{"$f":"AA46-AB46-AC48+AD46","v":114933.04399999999},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A46,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":102650},1000,0,{"$f":"(AF46-AG46-AH46)*12.36%","v":12563.939999999999},{"$f":"AF46-AG46-AH46+AI46","v":114213.94}]
["W52A009OG"]
["W52ASR009A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A48,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":103220},1000,0,{"$f":"(B48-C48-D48)*12.36%","v":12634.391999999998},{"$f":"B48-C48-D48+E48","v":114854.39199999999},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A48,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":103220},1000,0,{"$f":"(G48-H48-I48)*12.36%","v":12634.391999999998},{"$f":"G48-H48-I48+J48","v":114854.39199999999},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A48,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":102560},1000,0,{"$f":"(L48-M48-N48)*12.36%","v":12552.815999999999},{"$f":"L48-M48-N48+O48","v":114112.81599999999},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A48,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":103660},1000,0,{"$f":"(Q48-R48-S48)*12.36%","v":12688.775999999998},{"$f":"Q48-R48-S48+T48","v":115348.776},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A48,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":104800},1000,0,{"$f":"(V48-W48-X48)*12.36%","v":12829.679999999998},{"$f":"V48-W48-X50+Y48","v":116629.68},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A48,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":103290},1000,0,{"$f":"(AA48-AB48-AC48)*12.36%","v":12643.043999999998},{"$f":"AA48-AB48-AC50+AD48","v":114933.04399999999},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A48,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":102650},1000,0,{"$f":"(AF48-AG48-AH48)*12.36%","v":12563.939999999999},{"$f":"AF48-AG48-AH48+AI48","v":114213.94}]
["W55A004A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A49,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":106220},1000,0,{"$f":"(B49-C49-D49)*12.36%","v":13005.191999999999},{"$f":"B49-C49-D49+E49","v":118225.192},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A49,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":106220},1000,0,{"$f":"(G49-H49-I49)*12.36%","v":13005.191999999999},{"$f":"G49-H49-I49+J49","v":118225.192},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A49,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":105560},1000,0,{"$f":"(L49-M49-N49)*12.36%","v":12923.615999999998},{"$f":"L49-M49-N49+O49","v":117483.61599999999},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A49,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":106660},1000,0,{"$f":"(Q49-R49-S49)*12.36%","v":13059.575999999999},{"$f":"Q49-R49-S49+T49","v":118719.576},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A49,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":107800},1000,0,{"$f":"(V49-W49-X49)*12.36%","v":13200.48},{"$f":"V49-W49-X49+Y49","v":120000.48},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A49,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":106290},1000,0,{"$f":"(AA49-AB49-AC49)*12.36%","v":13013.843999999999},{"$f":"AA49-AB49-AC51+AD49","v":118303.844},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A49,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":105650},1000,0,{"$f":"(AF49-AG49-AH49)*12.36%","v":12934.739999999998},{"$f":"AF49-AG49-AH49+AI49","v":117584.73999999999}]
["LLDPE"]
["E20AN009A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A51,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":107980},1000,0,{"$f":"(B51-C51-D51)*12.36%","v":13222.727999999999},{"$f":"B51-C51-D51+E51","v":120202.728},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A51,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":107980},1000,0,{"$f":"(G51-H51-I51)*12.36%","v":13222.727999999999},{"$f":"G51-H51-I51+J51","v":120202.728},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A51,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":107330},1000,0,{"$f":"(L51-M51-N51)*12.36%","v":13142.387999999999},{"$f":"L51-M51-N51+O51","v":119472.38800000001},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A51,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":108420},1000,0,{"$f":"(Q51-R51-S51)*12.36%","v":13277.111999999999},{"$f":"Q51-R51-S51+T51","v":120697.11199999999},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A51,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":109570},1000,0,{"$f":"(V51-W51-X51)*12.36%","v":13419.251999999999},{"$f":"V51-W51-X51+Y51","v":121989.25199999999},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A51,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":108050},1000,0,{"$f":"(AA51-AB51-AC51)*12.36%","v":13231.38},{"$f":"AA51-AB51-AC51+AD51","v":120281.38},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A51,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":107410},1000,0,{"$f":"(AF51-AG51-AH51)*12.36%","v":13152.275999999998},{"$f":"AF51-AG51-AH51+AI51","v":119562.276}]
["E20AN009OG"]
["E36A060A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A53,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":111020},1000,0,{"$f":"(B53-C53-D53)*12.36%","v":13598.471999999998},{"$f":"B53-C53-D53+E53","v":123618.47199999999},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A53,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":111020},1000,0,{"$f":"(G53-H53-I53)*12.36%","v":13598.471999999998},{"$f":"G53-H53-I53+J53","v":123618.47199999999},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A53,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":110370},1000,0,{"$f":"(L53-M53-N53)*12.36%","v":13518.131999999998},{"$f":"L53-M53-N53+O53","v":122888.132},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A53,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":111470},1000,0,{"$f":"(Q53-R53-S53)*12.36%","v":13654.091999999999},{"$f":"Q53-R53-S53+T53","v":124124.092},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A53,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":112610},1000,0,{"$f":"(V53-W53-X53)*12.36%","v":13794.995999999999},{"$f":"V53-W53-X53+Y53","v":125404.996},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A53,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":111090},1000,0,{"$f":"(AA53-AB53-AC53)*12.36%","v":13607.123999999998},{"$f":"AA53-AB53-AC53+AD53","v":123697.124},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A53,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":110450},1000,0,{"$f":"(AF53-AG53-AH53)*12.36%","v":13528.019999999999},{"$f":"AF53-AG53-AH53+AI53","v":122978.02}]
["E36A060OG"]
["FILM"]
["F20S009A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A56,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":109480},1000,0,{"$f":"(B56-C56-D56)*12.36%","v":13408.127999999999},{"$f":"B56-C56-D56+E56","v":121888.128},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A56,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":109480},1000,0,{"$f":"(G56-H56-I56)*12.36%","v":13408.127999999999},{"$f":"G56-H56-I56+J56","v":121888.128},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A56,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":108830},1000,0,{"$f":"(L56-M56-N56)*12.36%","v":13327.787999999999},{"$f":"L56-M56-N56+O56","v":121157.788},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A56,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":109920},1000,0,{"$f":"(Q56-R56-S56)*12.36%","v":13462.511999999999},{"$f":"Q56-R56-S56+T56","v":122382.512},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A56,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":111070},1000,0,{"$f":"(V56-W56-X56)*12.36%","v":13604.651999999998},{"$f":"V56-W56-X56+Y56","v":123674.652},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A56,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":109550},1000,0,{"$f":"(AA56-AB56-AC56)*12.36%","v":13416.779999999999},{"$f":"AA56-AB56-AC56+AD56","v":121966.78},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A56,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":108910},1000,0,{"$f":"(AF56-AG56-AH56)*12.36%","v":13337.675999999999},{"$f":"AF56-AG56-AH56+AI56","v":121247.67600000001}]
["F20S009OG"]
["D22S010A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A58,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":108480},1000,0,{"$f":"(B58-C58-D58)*12.36%","v":13284.527999999998},{"$f":"B58-C58-D58+E58","v":120764.52799999999},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A58,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":108480},1000,0,{"$f":"(G58-H58-I58)*12.36%","v":13284.527999999998},{"$f":"G58-H58-I58+J58","v":120764.52799999999},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A58,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":107830},1000,0,{"$f":"(L58-M58-N58)*12.36%","v":13204.187999999998},{"$f":"L58-M58-N58+O58","v":120034.18799999999},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A58,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":108920},1000,0,{"$f":"(Q58-R58-S58)*12.36%","v":13338.911999999998},{"$f":"Q58-R58-S58+T58","v":121258.912},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A58,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":110070},1000,0,{"$f":"(V58-W58-X58)*12.36%","v":13481.051999999998},{"$f":"V58-W58-X58+Y58","v":122551.052},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A58,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":108550},1000,0,{"$f":"(AA58-AB58-AC58)*12.36%","v":13293.179999999998},{"$f":"AA58-AB58-AC58+AD58","v":120843.18},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A58,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":107910},1000,0,{"$f":"(AF58-AG58-AH58)*12.36%","v":13214.075999999999},{"$f":"AF58-AG58-AH58+AI58","v":120124.076}]
["ROTO"]
["R35A042A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A60,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":108000},1000,0,{"$f":"(B60-C60-D60)*12.36%","v":13225.199999999999},{"$f":"B60-C60-D60+E60","v":120225.2},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A60,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":108010},1000,0,{"$f":"(G60-H60-I60)*12.36%","v":13226.435999999998},{"$f":"G60-H60-I60+J60","v":120236.436},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A60,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":107420},1000,0,{"$f":"(L60-M60-N60)*12.36%","v":13153.511999999999},{"$f":"L60-M60-N60+O60","v":119573.512},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A60,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":108450},1000,0,{"$f":"(Q60-R60-S60)*12.36%","v":13280.819999999998},{"$f":"Q60-R60-S60+T60","v":120730.81999999999},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A60,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":109590},1000,0,{"$f":"(V60-W60-X60)*12.36%","v":13421.723999999998},{"$f":"V60-W60-X60+Y60","v":122011.724},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A60,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":108060},1000,0,{"$f":"(AA60-AB60-AC60)*12.36%","v":13232.615999999998},{"$f":"AA60-AB60-AC60+AD60","v":120292.61599999999},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A60,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":107540},1000,0,{"$f":"(AF60-AG60-AH60)*12.36%","v":13168.343999999999},{"$f":"AF60-AG60-AH60+AI60","v":119708.344}]
["R35U042A",{"$f":"IF(B$8=\"Daman\",HLOOKUP($A61,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,3,0))","v":108860},1000,0,{"$f":"(B61-C61-D61)*12.36%","v":13331.495999999999},{"$f":"B61-C61-D61+E61","v":121191.496},{"$f":"IF(G$8=\"SILVASSA\",HLOOKUP($A61,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,4,0))","v":108870},1000,0,{"$f":"(G61-H61-I61)*12.36%","v":13332.731999999998},{"$f":"G61-H61-I61+J61","v":121202.732},{"$f":"IF(L$8=\"MUMBAI/BHIWANDI/THANE\",HLOOKUP($A61,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,5,0))","v":108280},1000,0,{"$f":"(L61-M61-N61)*12.36%","v":13259.807999999999},{"$f":"L61-M61-N61+O61","v":120539.808},{"$f":"IF(Q$8=\"JALGAON\",HLOOKUP($A61,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,6,0))","v":109310},1000,0,{"$f":"(Q61-R61-S61)*12.36%","v":13387.115999999998},{"$f":"Q61-R61-S61+T61","v":121697.11599999999},{"$f":"IF(V$8=\"NAGPUR\",HLOOKUP($A61,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,7,0))","v":110450},1000,0,{"$f":"(V61-W61-X61)*12.36%","v":13528.019999999999},{"$f":"V61-W61-X61+Y61","v":122978.02},{"$f":"IF(AA$8=\"AURANGABAD\",HLOOKUP($A61,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,8,0))","v":108920},1000,0,{"$f":"(AA61-AB61-AC61)*12.36%","v":13338.911999999998},{"$f":"AA61-AB61-AC61+AD61","v":121258.912},{"$f":"IF(AF$8=\"SANGLI\",HLOOKUP($A61,'[1]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,9,0))","v":108400},1000,0,{"$f":"(AF61-AG61-AH61)*12.36%","v":13274.64},{"$f":"AF61-AG61-AH61+AI61","v":120674.64}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
["NOTE:","LOCATION DISCOUNT HAS BEEN DISCONTINUED"]
[]
[null," THE PRICES OF OLD PLANT & NEW PLANT  ARE SAME FROM DIRECT SALE"]

{"sheet":"Sheet2","index":1,"n_rows":66,"n_cols":41,"rows_kept":66,"cut":false,"hidden":false,"merged":[[8,26,8,30],[8,16,8,20],[8,21,8,25],[8,31,8,35],[8,36,8,40],[8,1,8,5],[8,6,8,10],[8,11,8,15],[1,0,1,25],[2,0,2,25],[3,0,3,25],[4,0,4,25],[5,0,5,25],[6,0,6,25]]}
[]
["UNITED BROTHERS"]
["CONSIGNMENT STOCKIST OF GAIL (INDIA) LTD"]
["301,HERITAGE PLAZA, R.S.MAHARAJ MARG,( TELI GALLI CROSS LANE), ANDHERI (E), MUMBAI - 400 069"]
["EL:  26844612(4 LINES) FAX: 26822914  E-MAIL: info@unibrothers.com, prashant@unibrothers.com,jyoti@unibrotehers.com"]
["EX-WORKS PRICE OF HDPE \"G-LEX / G-LENE \" W.E.F. 1ST MAY  2014"]
["CASH / ADVANCE PAYMENT FOR MAHARASHTRA & DAMAN"]
[null,"Freight",null,2833.73,null,null,"Freight",null,2016.35,null,null,"Freight",null,2640.33,null,null,"Freight",null,2825.33,null,null,"Freight",null,2282.96,null,null,"                   Freight  ",null,3163.78,null,null,"                    Freight      1986.51",2446.9299999999998,null,null,null,"FREIGHT",2814.81]
[null,"SOLAPUR",null,null,null,null,"UMBERGAON",null,null,null,null,"PUNE",null,null,null,null,"WAI",null,null,null,null,"NASIK",null,null,null,null,"KOLHAPUR",null,null,null,null,"AHMEDNAGAR",null,null,null,null,"ROHA"]
[null,"BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS",null,"DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS",null,"DISC","LOC","EXCISE","EX-WKS"]
["BM"]
["B52A003A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":105780},1000,0,{"$f":"(B12-C12-D12)*12.36%","v":12950.807999999999},{"$f":"B12-C12-D12+E12","v":117730.808},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":106720},1000,0,{"$f":"(G12-H12-I12)*12.36%","v":13066.991999999998},{"$f":"G12-H12-I12+J12","v":118786.992},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":105760},1000,0,{"$f":"(L12-M12-N12)*12.36%","v":12948.335999999999},{"$f":"L12-M12-N12+O12","v":117708.336},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":105760},1000,0,{"$f":"(Q12-R12-S12)*12.36%","v":12948.335999999999},{"$f":"Q12-R12-S12+T12","v":117708.336},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":106190},1000,0,{"$f":"(V12-W12-X12)*12.36%","v":13001.483999999999},{"$f":"V12-W12-X12+Y12","v":118191.484},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":105610},1000,0,{"$f":"(AA12-AB12-AC12)*12.36%","v":12929.795999999998},{"$f":"AA12-AB12-AC12+AD12","v":117539.796},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":106410},1000,0,{"$f":"(AF13-AG12-AH12)*12.36%","v":13028.675999999999},{"$f":"AF13-AG12-AH12+AI12","v":118438.67600000001},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":106190},1000,0,{"$f":"(AK12-AL12-AM12)*12.36%","v":13001.483999999999},{"$f":"AK12-AL12-AM12+AN12","v":118191.484}]
["B63A003A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":105780},1000,0,{"$f":"(B13-C13-D13)*12.36%","v":12950.807999999999},{"$f":"B13-C13-D13+E13","v":117730.808},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":106720},1000,0,{"$f":"(G13-H13-I13)*12.36%","v":13066.991999999998},{"$f":"G13-H13-I13+J13","v":118786.992},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":105760},1000,0,{"$f":"(L13-M13-N13)*12.36%","v":12948.335999999999},{"$f":"L13-M13-N13+O13","v":117708.336},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":105760},1000,0,{"$f":"(Q13-R13-S13)*12.36%","v":12948.335999999999},{"$f":"Q13-R13-S13+T13","v":117708.336},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":106190},1000,0,{"$f":"(V13-W13-X13)*12.36%","v":13001.483999999999},{"$f":"V13-W13-X13+Y13","v":118191.484},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":105610},1000,0,{"$f":"(AA13-AB13-AC13)*12.36%","v":12929.795999999998},{"$f":"AA13-AB13-AC13+AD13","v":117539.796},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":106410},1000,0,{"$f":"(AF14-AG13-AH13)*12.36%","v":13523.075999999999},{"$f":"AF14-AG13-AH13+AI13","v":122933.076},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":106190},1000,0,{"$f":"(AK13-AL13-AM13)*12.36%","v":13001.483999999999},{"$f":"AK13-AL13-AM13+AN13","v":118191.484}]
["B55HM0003A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":109890},1000,0,{"$f":"(B14-C14-D14)*12.36%","v":13458.803999999998},{"$f":"B14-C14-D14+E14","v":122348.804},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":111090},1000,0,{"$f":"(G14-H14-I14)*12.36%","v":13607.123999999998},{"$f":"G14-H14-I14+J14","v":123697.124},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":109790},1000,0,{"$f":"(L14-M14-N14)*12.36%","v":13446.444},{"$f":"L14-M14-N14+O14","v":122236.444},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":109790},1000,0,{"$f":"(Q14-R14-S14)*12.36%","v":13446.444},{"$f":"Q14-R14-S14+T14","v":122236.444},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":110140},1000,0,{"$f":"(V14-W14-X14)*12.36%","v":13489.703999999998},{"$f":"V14-W14-X14+Y14","v":122629.704},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":109580},1000,0,{"$f":"(AA14-AB14-AC14)*12.36%","v":13420.487999999999},{"$f":"AA14-AB14-AC14+AD14","v":122000.488},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":110410},1000,0,{"$f":"(AF14-AG14-AH14)*12.36%","v":13523.075999999999},{"$f":"AF14-AG14-AH14+AI14","v":122933.076},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":110140},1000,0,{"$f":"(AK14-AL14-AM14)*12.36%","v":13489.703999999998},{"$f":"AK14-AL14-AM14+AN14","v":122629.704}]
["B53EA0035A",null,null,null,null,null,{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A15,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":107220},1000,0,{"$f":"(G15-H15-I15)*12.36%","v":13128.791999999999},{"$f":"G15-H15-I15+J15","v":119348.792}]
["CABLE-INSUL"]
["C43D006A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A17,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":103363.5},1000,0,{"$f":"(B17-C17-D17)*12.36%","v":12652.128599999998},{"$f":"B17-C17-D17+E17","v":115015.6286},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A17,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":103886},1000,0,{"$f":"(G17-H17-I17)*12.36%","v":12716.709599999998},{"$f":"G17-H17-I17+J17","v":115602.7096},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A17,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":103335},1000,0,{"$f":"(L17-M17-N17)*12.36%","v":12648.605999999998},{"$f":"L17-M17-N17+O17","v":114983.606},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A17,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":103335},1000,0,{"$f":"(Q17-R17-S17)*12.36%","v":12648.605999999998},{"$f":"Q17-R17-S17+T17","v":114983.606},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A17,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":103724.5},1000,0,{"$f":"(V17-W17-X17)*12.36%","v":12696.748199999998},{"$f":"V17-W17-X17+Y17","v":115421.2482},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A17,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":103173.5},1000,0,{"$f":"(AA17-AB17-AC17)*12.36%","v":12628.6446},{"$f":"AA17-AB17-AC17+AD17","v":114802.1446},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A17,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":103971.5},1000,0,{"$f":"(AF17-AG17-AH17)*12.36%","v":12727.277399999999},{"$f":"AF17-AG17-AH17+AI17","v":115698.77739999999},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A17,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":103724.5},1000,0,{"$f":"(AK17-AL17-AM17)*12.36%","v":12696.748199999998},{"$f":"AK17-AL17-AM17+AN17","v":115421.2482}]
[]
["SHETG"]
["E45A003A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A20,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":104380},1000,0,{"$f":"(B20-C20-D20)*12.36%","v":12777.767999999998},{"$f":"B20-C20-D20+E20","v":116157.768},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A20,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":105080},1000,0,{"$f":"(G20-H20-I20)*12.36%","v":12864.287999999999},{"$f":"G20-H20-I20+J20","v":116944.288},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A20,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":104350},1000,0,{"$f":"(L20-M20-N20)*12.36%","v":12774.06},{"$f":"L20-M20-N20+O20","v":116124.06},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A20,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":104350},1000,0,{"$f":"(Q20-R20-S20)*12.36%","v":12774.06},{"$f":"Q20-R20-S20+T20","v":116124.06},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A20,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":104750},1000,0,{"$f":"(V20-W20-X20)*12.36%","v":12823.499999999998},{"$f":"V20-W20-X20+Y20","v":116573.5},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A20,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":104180},1000,0,{"$f":"(AA20-AB20-AC20)*12.36%","v":12753.047999999999},{"$f":"AA20-AB20-AC20+AD20","v":115933.048},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A20,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":105020},1000,0,{"$f":"(AF20-AG20-AH20)*12.36%","v":12856.871999999999},{"$f":"AF20-AG20-AH20+AI20","v":116876.872},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A20,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":104750},1000,0,{"$f":"(AK20-AL20-AM20)*12.36%","v":12823.499999999998},{"$f":"AK20-AL20-AM20+AN20","v":116573.5}]
["E45A003OG"]
["EXTR "]
["E52A003A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":107050},1000,0,{"$f":"(B23-C23-D23)*12.36%","v":13107.779999999999},{"$f":"B23-C23-D23+E23","v":119157.78},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":107680},1000,0,{"$f":"(G23-H23-I23)*12.36%","v":13185.647999999999},{"$f":"G23-H23-I23+J23","v":119865.648},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":107020},1000,0,{"$f":"(L23-M23-N23)*12.36%","v":13104.071999999998},{"$f":"L23-M23-N23+O23","v":119124.072},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":107020},1000,0,{"$f":"(Q23-R23-S23)*12.36%","v":13104.071999999998},{"$f":"Q23-R23-S23+T23","v":119124.072},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":107420},1000,0,{"$f":"(V23-W23-X23)*12.36%","v":13153.511999999999},{"$f":"V23-W23-X23+Y23","v":119573.512},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":106850},1000,0,{"$f":"(AA23-AB23-AC23)*12.36%","v":13083.06},{"$f":"AA23-AB23-AC23+AD23","v":118933.06},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":107680},1000,0,{"$f":"(AF23-AG23-AH23)*12.36%","v":13185.647999999999},{"$f":"AF23-AG23-AH23+AI23","v":119865.648},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":107420},1000,0,{"$f":"(AK23-AL23-AM23)*12.36%","v":13153.511999999999},{"$f":"AK23-AL23-AM23+AN23","v":119573.512}]
["E52A003OG"]
["E52U003A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A25,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":110830},1000,0,{"$f":"(B25-C25-D25)*12.36%","v":13574.987999999999},{"$f":"B25-C25-D25+E25","v":123404.988},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A25,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":111460},1000,0,{"$f":"(G25-H25-I25)*12.36%","v":13652.855999999998},{"$f":"G25-H25-I25+J25","v":124112.856},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A25,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":110800},1000,0,{"$f":"(L25-M25-N25)*12.36%","v":13571.279999999999},{"$f":"L25-M25-N25+O25","v":123371.28},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A25,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":110800},1000,0,{"$f":"(Q25-R25-S25)*12.36%","v":13571.279999999999},{"$f":"Q25-R25-S25+T25","v":123371.28},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A25,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":111200},1000,0,{"$f":"(V25-W25-X25)*12.36%","v":13620.72},{"$f":"V25-W25-X25+Y25","v":123820.72},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A25,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":110630},1000,0,{"$f":"(AA25-AB25-AC25)*12.36%","v":13550.267999999998},{"$f":"AA25-AB25-AC25+AD25","v":123180.268},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A25,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":111460},1000,0,{"$f":"(AF25-AG25-AH25)*12.36%","v":13652.855999999998},{"$f":"AF25-AG25-AH25+AI25","v":124112.856},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A25,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":111200},1000,0,{"$f":"(AK25-AL25-AM25)*12.36%","v":13620.72},{"$f":"AK25-AL25-AM25+AN25","v":123820.72}]
["E52U003OG"]
["HM FILM"]
["F55HM0003A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A28,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":105440},1000,0,{"$f":"(B28-C28-D28)*12.36%","v":12908.783999999998},{"$f":"B28-C28-D28+E28","v":117348.784},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A28,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":106140},1000,0,{"$f":"(G28-H28-I28)*12.36%","v":12995.303999999998},{"$f":"G28-H28-I28+J28","v":118135.304},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A28,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":105340},1000,0,{"$f":"(L28-M28-N28)*12.36%","v":12896.423999999999},{"$f":"L28-M28-N28+O28","v":117236.424},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A28,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":105340},1000,0,{"$f":"(Q28-R28-S28)*12.36%","v":12896.423999999999},{"$f":"Q28-R28-S28+T28","v":117236.424},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A28,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":105690},1000,0,{"$f":"(V28-W28-X28)*12.36%","v":12939.683999999999},{"$f":"V28-W28-X28+Y28","v":117629.68399999999},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A28,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":105130},1000,0,{"$f":"(AA28-AB28-AC28)*12.36%","v":12870.467999999999},{"$f":"AA28-AB28-AC28+AD28","v":117000.46799999999},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A28,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":105960},1000,0,{"$f":"(AF28-AG28-AH28)*12.36%","v":12973.055999999999},{"$f":"AF28-AG28-AH28+AI28","v":117933.056},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A28,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":105690},1000,0,{"$f":"(AK28-AL28-AM28)*12.36%","v":12939.683999999999},{"$f":"AK28-AL28-AM28+AN28","v":117629.68399999999}]
["F55HM0003OG"]
["IM HIGH"]
["I50A180A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A31,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":101840},1000,0,{"$f":"(B31-C31-D31)*12.36%","v":12463.823999999999},{"$f":"B31-C31-D31+E31","v":113303.82399999999},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A31,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":102440},1000,0,{"$f":"(G31-H31-I31)*12.36%","v":12537.983999999999},{"$f":"G31-H31-I31+J31","v":113977.984},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A31,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":101720},1000,0,{"$f":"(L31-M31-N31)*12.36%","v":12448.991999999998},{"$f":"L31-M31-N31+O31","v":113168.992},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A31,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":101720},1000,0,{"$f":"(Q31-R31-S31)*12.36%","v":12448.991999999998},{"$f":"Q31-R31-S31+T31","v":113168.992},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A31,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":102040},1000,0,{"$f":"(V31-W31-X31)*12.36%","v":12488.543999999998},{"$f":"V31-W31-X31+Y31","v":113528.54399999999},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A31,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":101560},1000,0,{"$f":"(AA31-AB31-AC31)*12.36%","v":12429.215999999999},{"$f":"AA31-AB31-AC31+AD31","v":112989.216},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A31,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":102300},1000,0,{"$f":"(AF31-AG31-AH31)*12.36%","v":12520.679999999998},{"$f":"AF31-AG31-AH31+AI31","v":113820.68},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A31,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":102040},1000,0,{"$f":"(AK31-AL31-AM31)*12.36%","v":12488.543999999998},{"$f":"AK31-AL31-AM31+AN31","v":113528.54399999999}]
["I50A180OG"]
["IM LOW"]
["I60A080A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A34,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":103020},1000,0,{"$f":"(B34-C34-D34)*12.36%","v":12609.671999999999},{"$f":"B34-C34-D34+E34","v":114629.67199999999},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A34,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":103680},1000,0,{"$f":"(G34-H34-I34)*12.36%","v":12691.248},{"$f":"G34-H34-I34+J34","v":115371.24799999999},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A34,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":103000},1000,0,{"$f":"(L34-M34-N34)*12.36%","v":12607.199999999999},{"$f":"L34-M34-N34+O34","v":114607.2},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A34,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":103000},1000,0,{"$f":"(Q34-R34-S34)*12.36%","v":12607.199999999999},{"$f":"Q34-R34-S34+T34","v":114607.2},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A34,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":103400},1000,0,{"$f":"(V34-W34-X34)*12.36%","v":12656.64},{"$f":"V34-W34-X34+Y34","v":115056.64},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A34,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":102830},1000,0,{"$f":"(AA34-AB34-AC34)*12.36%","v":12586.187999999998},{"$f":"AA34-AB34-AC34+AD34","v":114416.18799999999},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A34,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":103660},1000,0,{"$f":"(AF34-AG34-AH34)*12.36%","v":12688.775999999998},{"$f":"AF34-AG34-AH34+AI34","v":115348.776},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A34,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":103400},1000,0,{"$f":"(AK34-AL34-AM34)*12.36%","v":12656.64},{"$f":"AK34-AL34-AM34+AN34","v":115056.64}]
["I60A080OG"]
["IM-L-UV"]
["I60U080A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A37,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":104560},1000,0,{"$f":"(B37-C37-D37)*12.36%","v":12800.016},{"$f":"B37-C37-D37+E37","v":116360.016},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A37,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":105180},1000,0,{"$f":"(G37-H37-I37)*12.36%","v":12876.647999999999},{"$f":"G37-H37-I37+J37","v":117056.648},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A37,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":104530},1000,0,{"$f":"(L37-M37-N37)*12.36%","v":12796.307999999999},{"$f":"L37-M37-N37+O37","v":116326.308},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A37,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":104530},1000,0,{"$f":"(Q37-R37-S37)*12.36%","v":12796.307999999999},{"$f":"Q37-R37-S37+T37","v":116326.308},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A37,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":104930},1000,0,{"$f":"(V37-W37-X37)*12.36%","v":12845.748},{"$f":"V37-W37-X37+Y37","v":116775.74799999999},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A37,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":104360},1000,0,{"$f":"(AA37-AB37-AC37)*12.36%","v":12775.295999999998},{"$f":"AA37-AB37-AC37+AD37","v":116135.296},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A37,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":105200},1000,0,{"$f":"(AF37-AG37-AH37)*12.36%","v":12879.119999999999},{"$f":"AF37-AG37-AH37+AI37","v":117079.12},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A37,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":104930},1000,0,{"$f":"(AK37-AL37-AM37)*12.36%","v":12845.748},{"$f":"AK37-AL37-AM37+AN37","v":116775.74799999999}]
["I60U080OG"]
["PIPE (PE80)"]
["P54A001A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":112150},1000,0,{"$f":"(B40-C40-D40)*12.36%","v":13738.14},{"$f":"B40-C40-D40+E40","v":124888.14},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":112850},1000,0,{"$f":"(G40-H40-I40)*12.36%","v":13824.659999999998},{"$f":"G40-H40-I40+J40","v":125674.66},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":112050},1000,0,{"$f":"(L40-M40-N40)*12.36%","v":13725.779999999999},{"$f":"L40-M40-N40+O40","v":124775.78},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":112050},1000,0,{"$f":"(Q40-R40-S40)*12.36%","v":13725.779999999999},{"$f":"Q40-R40-S40+T40","v":124775.78},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":112400},1000,0,{"$f":"(V40-W40-X40)*12.36%","v":13769.039999999999},{"$f":"V40-W40-X40+Y40","v":125169.04},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":111840},1000,0,{"$f":"(AA40-AB40-AC40)*12.36%","v":13699.823999999999},{"$f":"AA40-AB40-AC40+AD40","v":124539.82399999999},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":112670},1000,0,{"$f":"(AF40-AG40-AH40)*12.36%","v":13802.411999999998},{"$f":"AF40-AG40-AH40+AI40","v":125472.412},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":112400},1000,0,{"$f":"(AK40-AL40-AM40)*12.36%","v":13769.039999999999},{"$f":"AK40-AL40-AM40+AN40","v":125169.04}]
["PIPE (PE100)"]
["P52A003A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":114150},1000,0,{"$f":"(B42-C42-D42)*12.36%","v":13985.339999999998},{"$f":"B42-C42-D42+E42","v":127135.34},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":114850},1000,0,{"$f":"(G42-H42-I42)*12.36%","v":14071.859999999999},{"$f":"G42-H42-I42+J42","v":127921.86},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":114050},1000,0,{"$f":"(L42-M42-N42)*12.36%","v":13972.979999999998},{"$f":"L42-M42-N42+O42","v":127022.98},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":114050},1000,0,{"$f":"(Q42-R42-S42)*12.36%","v":13972.979999999998},{"$f":"Q42-R42-S42+T42","v":127022.98},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":114400},1000,0,{"$f":"(V42-W42-X42)*12.36%","v":14016.239999999998},{"$f":"V42-W42-X42+Y42","v":127416.23999999999},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":113840},1000,0,{"$f":"(AA42-AB42-AC42)*12.36%","v":13947.023999999999},{"$f":"AA42-AB42-AC42+AD42","v":126787.024},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":114670},1000,0,{"$f":"(AF42-AG42-AH42)*12.36%","v":14049.611999999999},{"$f":"AF42-AG42-AH42+AI42","v":127719.61199999999},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":114400},1000,0,{"$f":"(AK42-AL42-AM42)*12.36%","v":14016.239999999998},{"$f":"AK42-AL42-AM42+AN42","v":127416.23999999999}]
["RAFFIA"]
["W50A009A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":106150},1000,0,{"$f":"(B44-C44-D44)*12.36%","v":12996.539999999999},{"$f":"B44-C44-D44+E44","v":118146.54},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":106680},1000,0,{"$f":"(G44-H44-I44)*12.36%","v":13062.047999999999},{"$f":"G44-H44-I44+J44","v":118742.048},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":106120},1000,0,{"$f":"(L44-M44-N44)*12.36%","v":12992.831999999999},{"$f":"L44-M44-N44+O44","v":118112.83199999999},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":106120},1000,0,{"$f":"(Q44-R44-S44)*12.36%","v":12992.831999999999},{"$f":"Q44-R44-S44+T44","v":118112.83199999999},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":106520},1000,0,{"$f":"(V44-W44-X44)*12.36%","v":13042.271999999999},{"$f":"V44-W44-X44+Y44","v":118562.272},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":105950},1000,0,{"$f":"(AA44-AB44-AC44)*12.36%","v":12971.819999999998},{"$f":"AA44-AB44-AC44+AD44","v":117921.81999999999},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":106790},1000,0,{"$f":"(AF44-AG44-AH44)*12.36%","v":13075.643999999998},{"$f":"AF44-AG44-AH44+AI44","v":118865.644},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":106520},1000,0,{"$f":"(AK44-AL44-AM44)*12.36%","v":13042.271999999999},{"$f":"AK44-AL44-AM44+AN44","v":118562.272}]
["T50A010A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":106150},1000,0,{"$f":"(B45-C45-D45)*12.36%","v":12996.539999999999},{"$f":"B45-C45-D45+E45","v":118146.54},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":106680},1000,0,{"$f":"(G45-H45-I45)*12.36%","v":13062.047999999999},{"$f":"G45-H45-I45+J45","v":118742.048},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":106120},1000,0,{"$f":"(L45-M45-N45)*12.36%","v":12992.831999999999},{"$f":"L45-M45-N45+O45","v":118112.83199999999},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":106120},1000,0,{"$f":"(Q45-R45-S45)*12.36%","v":12992.831999999999},{"$f":"Q45-R45-S45+T45","v":118112.83199999999},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":106520},1000,0,{"$f":"(V45-W45-X45)*12.36%","v":13042.271999999999},{"$f":"V45-W45-X45+Y45","v":118562.272},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":105950},1000,0,{"$f":"(AA45-AB45-AC45)*12.36%","v":12971.819999999998},{"$f":"AA45-AB45-AC45+AD45","v":117921.81999999999},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":106790},1000,0,{"$f":"(AF45-AG45-AH45)*12.36%","v":13075.643999999998},{"$f":"AF45-AG45-AH45+AI45","v":118865.644},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":106520},1000,0,{"$f":"(AK45-AL45-AM45)*12.36%","v":13042.271999999999},{"$f":"AK45-AL45-AM45+AN45","v":118562.272}]
["MF"]
["W52A009A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":102650},1000,0,{"$f":"(B47-C47-D47)*12.36%","v":12563.939999999999},{"$f":"B47-C47-D47+E47","v":114213.94},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":103180},1000,0,{"$f":"(G47-H47-I47)*12.36%","v":12629.447999999999},{"$f":"G47-H47-I47+J47","v":114809.448},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":102620},1000,0,{"$f":"(L47-M47-N47)*12.36%","v":12560.231999999998},{"$f":"L47-M47-N47+O47","v":114180.232},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":102620},1000,0,{"$f":"(Q47-R47-S47)*12.36%","v":12560.231999999998},{"$f":"Q47-R47-S47+T47","v":114180.232},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":103020},1000,0,{"$f":"(V47-W47-X47)*12.36%","v":12609.671999999999},{"$f":"V47-W47-X47+Y47","v":114629.67199999999},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":102450},1000,0,{"$f":"(AA47-AB47-AC47)*12.36%","v":12539.22},{"$f":"AA47-AB47-AC47+AD47","v":113989.22},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":103290},1000,0,{"$f":"(AF47-AG47-AH47)*12.36%","v":12643.043999999998},{"$f":"AF47-AG47-AH47+AI47","v":114933.04399999999},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":103020},1000,0,{"$f":"(AK47-AL47-AM47)*12.36%","v":12609.671999999999},{"$f":"AK47-AL47-AM47+AN47","v":114629.67199999999}]
["W52A009OG"]
["W52ASR009A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":102650},1000,0,{"$f":"(B49-C49-D49)*12.36%","v":12563.939999999999},{"$f":"B49-C49-D49+E49","v":114213.94},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":103180},1000,0,{"$f":"(G49-H49-I49)*12.36%","v":12629.447999999999},{"$f":"G49-H49-I49+J49","v":114809.448},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":102620},1000,0,{"$f":"(L49-M49-N49)*12.36%","v":12560.231999999998},{"$f":"L49-M49-N49+O49","v":114180.232},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":102620},1000,0,{"$f":"(Q49-R49-S49)*12.36%","v":12560.231999999998},{"$f":"Q49-R49-S49+T49","v":114180.232},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":103020},1000,0,{"$f":"(V49-W49-X49)*12.36%","v":12609.671999999999},{"$f":"V49-W49-X49+Y49","v":114629.67199999999},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":102450},1000,0,{"$f":"(AA49-AB49-AC49)*12.36%","v":12539.22},{"$f":"AA49-AB49-AC49+AD49","v":113989.22},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":103290},1000,0,{"$f":"(AF49-AG49-AH49)*12.36%","v":12643.043999999998},{"$f":"AF49-AG49-AH49+AI49","v":114933.04399999999},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":103020},1000,0,{"$f":"(AK49-AL49-AM49)*12.36%","v":12609.671999999999},{"$f":"AK49-AL49-AM49+AN49","v":114629.67199999999}]
["W55A004A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":105650},1000,0,{"$f":"(B50-C50-D50)*12.36%","v":12934.739999999998},{"$f":"B50-C50-D50+E50","v":117584.73999999999},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":106180},1000,0,{"$f":"(G50-H50-I50)*12.36%","v":13000.248},{"$f":"G50-H50-I50+J50","v":118180.24799999999},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":105620},1000,0,{"$f":"(L50-M50-N50)*12.36%","v":12931.031999999999},{"$f":"L50-M50-N50+O50","v":117551.03200000001},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":105620},1000,0,{"$f":"(Q50-R50-S50)*12.36%","v":12931.031999999999},{"$f":"Q50-R50-S50+T50","v":117551.03200000001},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":106020},1000,0,{"$f":"(V50-W50-X50)*12.36%","v":12980.471999999998},{"$f":"V50-W50-X50+Y50","v":118000.47199999999},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":105450},1000,0,{"$f":"(AA50-AB50-AC50)*12.36%","v":12910.019999999999},{"$f":"AA50-AB50-AC50+AD50","v":117360.02},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":106290},1000,0,{"$f":"(AF50-AG50-AH50)*12.36%","v":13013.843999999999},{"$f":"AF50-AG50-AH50+AI50","v":118303.844},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":106020},1000,0,{"$f":"(AK50-AL50-AM50)*12.36%","v":12980.471999999998},{"$f":"AK50-AL50-AM50+AN50","v":118000.47199999999}]
["LLDPE"]
["E20AN009A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":107410},1000,0,{"$f":"(B52-C52-D52)*12.36%","v":13152.275999999998},{"$f":"B52-C52-D52+E52","v":119562.276},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":108080},1000,0,{"$f":"(G52-H52-I52)*12.36%","v":13235.087999999998},{"$f":"G52-H52-I52+J52","v":120315.088},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":107380},1000,0,{"$f":"(L52-M52-N52)*12.36%","v":13148.567999999999},{"$f":"L52-M52-N52+O52","v":119528.568},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":107380},1000,0,{"$f":"(Q52-R52-S52)*12.36%","v":13148.567999999999},{"$f":"Q52-R52-S52+T52","v":119528.568},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":107790},1000,0,{"$f":"(V52-W52-X52)*12.36%","v":13199.243999999999},{"$f":"V52-W52-X52+Y52","v":119989.24400000001},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":107210},1000,0,{"$f":"(AA52-AB52-AC52)*12.36%","v":13127.555999999999},{"$f":"AA52-AB52-AC52+AD52","v":119337.556},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":108050},1000,0,{"$f":"(AF52-AG52-AH52)*12.36%","v":13231.38},{"$f":"AF52-AG52-AH52+AI52","v":120281.38},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":107790},1000,0,{"$f":"(AK52-AL52-AM52)*12.36%","v":13199.243999999999},{"$f":"AK52-AL52-AM52+AN52","v":119989.24400000001}]
["E20AN009OG"]
["E36A060A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":110450},1000,0,{"$f":"(B54-C54-D54)*12.36%","v":13528.019999999999},{"$f":"B54-C54-D54+E54","v":122978.02},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":111080},1000,0,{"$f":"(G54-H54-I54)*12.36%","v":13605.887999999999},{"$f":"G54-H54-I54+J54","v":123685.88800000001},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":110430},1000,0,{"$f":"(L54-M54-N54)*12.36%","v":13525.547999999999},{"$f":"L54-M54-N54+O54","v":122955.548},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":110430},1000,0,{"$f":"(Q54-R54-S54)*12.36%","v":13525.547999999999},{"$f":"Q54-R54-S54+T54","v":122955.548},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":110830},1000,0,{"$f":"(V54-W54-X54)*12.36%","v":13574.987999999999},{"$f":"V54-W54-X54+Y54","v":123404.988},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":110260},1000,0,{"$f":"(AA54-AB54-AC54)*12.36%","v":13504.535999999998},{"$f":"AA54-AB54-AC54+AD54","v":122764.53599999999},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":111090},1000,0,{"$f":"(AF54-AG54-AH54)*12.36%","v":13607.123999999998},{"$f":"AF54-AG54-AH54+AI54","v":123697.124},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":110830},1000,0,{"$f":"(AK54-AL54-AM54)*12.36%","v":13574.987999999999},{"$f":"AK54-AL54-AM54+AN54","v":123404.988}]
["E36A060OG"]
["FILM"]
["F20S009A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":108910},1000,0,{"$f":"(B57-C57-D57)*12.36%","v":13337.675999999999},{"$f":"B57-C57-D57+E57","v":121247.67600000001},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":109580},1000,0,{"$f":"(G57-H57-I57)*12.36%","v":13420.487999999999},{"$f":"G57-H57-I57+J57","v":122000.488},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":108880},1000,0,{"$f":"(L57-M57-N57)*12.36%","v":13333.967999999999},{"$f":"L57-M57-N57+O57","v":121213.96799999999},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":108880},1000,0,{"$f":"(Q57-R57-S57)*12.36%","v":13333.967999999999},{"$f":"Q57-R57-S57+T57","v":121213.96799999999},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":109290},1000,0,{"$f":"(V57-W57-X57)*12.36%","v":13384.643999999998},{"$f":"V57-W57-X57+Y57","v":121674.644},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":108710},1000,0,{"$f":"(AA57-AB57-AC57)*12.36%","v":13312.955999999998},{"$f":"AA57-AB57-AC57+AD57","v":121022.95600000001},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":109550},1000,0,{"$f":"(AF57-AG57-AH57)*12.36%","v":13416.779999999999},{"$f":"AF57-AG57-AH57+AI57","v":121966.78},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":109290},1000,0,{"$f":"(AK57-AL57-AM57)*12.36%","v":13384.643999999998},{"$f":"AK57-AL57-AM57+AN57","v":121674.644}]
["F20S009OG"]
["D22S010A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":107910},1000,0,{"$f":"(B59-C59-D59)*12.36%","v":13214.075999999999},{"$f":"B59-C59-D59+E59","v":120124.076},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":108580},1000,0,{"$f":"(G59-H59-I59)*12.36%","v":13296.887999999999},{"$f":"G59-H59-I59+J59","v":120876.88800000001},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":107880},1000,0,{"$f":"(L59-M59-N59)*12.36%","v":13210.367999999999},{"$f":"L59-M59-N59+O59","v":120090.368},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":107880},1000,0,{"$f":"(Q59-R59-S59)*12.36%","v":13210.367999999999},{"$f":"Q59-R59-S59+T59","v":120090.368},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":108290},1000,0,{"$f":"(V59-W59-X59)*12.36%","v":13261.043999999998},{"$f":"V59-W59-X59+Y59","v":120551.04399999999},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":107710},1000,0,{"$f":"(AA59-AB59-AC59)*12.36%","v":13189.355999999998},{"$f":"AA59-AB59-AC59+AD59","v":119899.356},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":108550},1000,0,{"$f":"(AF59-AG59-AH59)*12.36%","v":13293.179999999998},{"$f":"AF59-AG59-AH59+AI59","v":120843.18},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":108290},1000,0,{"$f":"(AK59-AL59-AM59)*12.36%","v":13261.043999999998},{"$f":"AK59-AL59-AM59+AN59","v":120551.04399999999}]
["ROTO"]
["R35A042A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":107540},1000,0,{"$f":"(B61-C61-D61)*12.36%","v":13168.343999999999},{"$f":"B61-C61-D61+E61","v":119708.344},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":108240},1000,0,{"$f":"(G61-H61-I61)*12.36%","v":13254.864},{"$f":"G61-H61-I61+J61","v":120494.864},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":107440},1000,0,{"$f":"(L61-M61-N61)*12.36%","v":13155.983999999999},{"$f":"L61-M61-N61+O61","v":119595.984},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":107440},1000,0,{"$f":"(Q61-R61-S61)*12.36%","v":13155.983999999999},{"$f":"Q61-R61-S61+T61","v":119595.984},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":107790},1000,0,{"$f":"(V61-W61-X61)*12.36%","v":13199.243999999999},{"$f":"V61-W61-X61+Y61","v":119989.24400000001},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":107230},1000,0,{"$f":"(AA61-AB61-AC61)*12.36%","v":13130.027999999998},{"$f":"AA61-AB61-AC61+AD61","v":119360.02799999999},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":108060},1000,0,{"$f":"(AF61-AG61-AH61)*12.36%","v":13232.615999999998},{"$f":"AF61-AG61-AH61+AI61","v":120292.61599999999},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":107790},1000,0,{"$f":"(AK61-AL61-AM61)*12.36%","v":13199.243999999999},{"$f":"AK61-AL61-AM61+AN61","v":119989.24400000001}]
["R35U042A",{"$f":"IF(B$9=\"SOLAPUR\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,10,0))","v":108400},1000,0,{"$f":"(B62-C62-D62)*12.36%","v":13274.64},{"$f":"B62-C62-D62+E62","v":120674.64},{"$f":"IF(G$9=\"UMBERGAON\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,11,0))","v":109100},1000,0,{"$f":"(G62-H62-I62)*12.36%","v":13361.159999999998},{"$f":"G62-H62-I62+J62","v":121461.16},{"$f":"IF(L$9=\"PUNE\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,12,0))","v":108300},1000,0,{"$f":"(L62-M62-N62)*12.36%","v":13262.279999999999},{"$f":"L62-M62-N62+O62","v":120562.28},{"$f":"IF(Q$9=\"WAI\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,13,0))","v":108300},1000,0,{"$f":"(Q62-R62-S62)*12.36%","v":13262.279999999999},{"$f":"Q62-R62-S62+T62","v":120562.28},{"$f":"IF(V$9=\"NASIK\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,14,0))","v":108650},1000,0,{"$f":"(V62-W62-X62)*12.36%","v":13305.539999999999},{"$f":"V62-W62-X62+Y62","v":120955.54},{"$f":"IF(AA$9=\"KOLHAPUR\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,15,0))","v":108090},1000,0,{"$f":"(AA62-AB62-AC62)*12.36%","v":13236.323999999999},{"$f":"AA62-AB62-AC62+AD62","v":120326.32399999999},{"$f":"IF(AF$9=\"AHMEDNAGAR\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,16,0))","v":108920},1000,0,{"$f":"(AF62-AG62-AH62)*12.36%","v":13338.911999999998},{"$f":"AF62-AG62-AH62+AI62","v":121258.912},{"$f":"IF(AK$9=\"ROHA\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,17,0))","v":108650},1000,0,{"$f":"(AK62-AL62-AM62)*12.36%","v":13305.539999999999},{"$f":"AK62-AL62-AM62+AN62","v":120955.54}]
[]
["NOTE:","LOCATION DISCOUNT HAS BEEN DISCONTINUED"]
[]
[null," THE PRICES OF OLD PLANT & NEW PLANT  ARE SAME FROM DIRECT SALE"]

{"sheet":"Sheet3","index":2,"n_rows":66,"n_cols":31,"rows_kept":66,"cut":false,"hidden":false,"merged":[[1,0,1,20],[2,0,2,20],[8,21,8,25],[3,0,3,20],[4,0,4,20],[6,0,6,20],[8,6,8,10],[8,11,8,15],[8,26,8,30],[8,16,8,20],[5,0,5,25]]}
[]
["UNITED BROTHERS"]
[]
["301,HERITAGE PLAZA, R.S.MAHARAJ MARG,( TELI GALLI CROSS LANE), ANDHERI (E), MUMBAI - 400 069"]
["EL:  26844612(4 LINES) FAX: 26822914  E-MAIL: info@unibrothers.com , prashant@unibrothers.com, jyoti@unibrothers.com"]
["EX-WORKS PRICE OF HDPE \"G-LEX / G-LENE \" W.E.F. 1ST MAY 2014"]
["CASH / ADVANCE PAYMENT FOR MAHARASHTRA & DAMAN"]
[null,"Freight",null,2507.0500000000002,null,null,"Freight",null,4749.82,null,null,"Freight",null,2573.77,null,null,"          Freight  1210.75",null,null,null,null,"Freight",null,5162.96,null,null,"Freight"]
[null,null,null,"BARJORA",null,null,"HOSUR",null,null,null,null,"JAMMU",null,null,null,null,"NOIDA",null,null,null,null,"PONDICHERRY",null,null,null,null,"BARODA"]
[null,"BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS",null,"DISC","LOC","EXCISE","EX-WKS",null,"DISC","LOC","EXCISE","EX-WKS"]
["BM"]
["B52A003A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":105380},1000,0,{"$f":"(B12-C12-D12)*12.36%","v":12901.367999999999},{"$f":"B12-C12-D12+E12","v":117281.368},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":103660},1000,0,{"$f":"(G12-H12-I12)*12.36%","v":12688.775999999998},{"$f":"G12-H12-I12+J12","v":115348.776},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":108780},1000,0,{"$f":"(L12-M12-N12)*12.36%","v":13321.607999999998},{"$f":"L12-M12-N12+O12","v":121101.60799999999},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":108740},1000,0,{"$f":"(Q12-R12-S12)*12.36%","v":13316.663999999999},{"$f":"Q12-R12-S12+T12","v":121056.664},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":103790},1000,0,{"$f":"(V12-W12-X12)*12.36%","v":12704.843999999999},{"$f":"V12-W12-X12+Y12","v":115494.844},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":107200},1000,0,{"$f":"(AA12-AB12-AC12)*12.36%","v":13126.319999999998},{"$f":"AA12-AB12-AC12+AD12","v":119326.31999999999}]
["B63A003A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":105380},1000,0,{"$f":"(B13-C13-D13)*12.36%","v":12901.367999999999},{"$f":"B13-C13-D13+E13","v":117281.368},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":103660},1000,0,{"$f":"(G13-H13-I13)*12.36%","v":12688.775999999998},{"$f":"G13-H13-I13+J13","v":115348.776},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":108780},1000,0,{"$f":"(L13-M13-N13)*12.36%","v":13321.607999999998},{"$f":"L13-M13-N13+O13","v":121101.60799999999},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":108740},1000,0,{"$f":"(Q13-R13-S13)*12.36%","v":13316.663999999999},{"$f":"Q13-R13-S13+T13","v":121056.664},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":103790},1000,0,{"$f":"(V13-W13-X13)*12.36%","v":12704.843999999999},{"$f":"V13-W13-X13+Y13","v":115494.844},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":107200},1000,0,{"$f":"(AA13-AB13-AC13)*12.36%","v":13126.319999999998},{"$f":"AA13-AB13-AC13+AD13","v":119326.31999999999}]
["B55HM0003A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":111670},1000,0,{"$f":"(B14-C14-D14)*12.36%","v":13678.811999999998},{"$f":"B14-C14-D14+E14","v":124348.81200000001},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":107900},1000,0,{"$f":"(G14-H14-I14)*12.36%","v":13212.839999999998},{"$f":"G14-H14-I14+J14","v":120112.84},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":112920},1000,0,{"$f":"(L14-M14-N14)*12.36%","v":13833.311999999998},{"$f":"L14-M14-N14+O14","v":125753.31200000001},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":112970},1000,0,{"$f":"(Q14-R14-S14)*12.36%","v":13839.491999999998},{"$f":"Q14-R14-S14+T14","v":125809.492},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":108930},1000,0,{"$f":"(V14-W14-X14)*12.36%","v":13340.147999999999},{"$f":"V14-W14-X14+Y14","v":121270.148},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A14,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":111060},1000,0,{"$f":"(AA14-AB14-AC14)*12.36%","v":13603.415999999999},{"$f":"AA14-AB14-AC14+AD14","v":123663.416}]
["CABLE-INSUL"]
["C43D006A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A16,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":104009.5},1000,0,{"$f":"(B16-C16-D16)*12.36%","v":12731.974199999999},{"$f":"B16-C16-D16+E16","v":115741.4742},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A16,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":101273.5},1000,0,{"$f":"(G16-H16-I16)*12.36%","v":12393.804599999999},{"$f":"G16-H16-I16+J16","v":112667.3046},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A16,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":106356},1000,0,{"$f":"(L16-M16-N16)*12.36%","v":13022.0016},{"$f":"L16-M16-N16+O16","v":118378.0016},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A16,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":106394},1000,0,{"$f":"(Q16-R16-S16)*12.36%","v":13026.698399999999},{"$f":"Q16-R16-S16+T16","v":118420.69839999999},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A16,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":101416},1000,0,{"$f":"(V16-W16-X16)*12.36%","v":12411.417599999999},{"$f":"V16-W16-X16+Y16","v":112827.4176},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A16,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":104370.5},1000,0,{"$f":"(AA16-AB16-AC16)*12.36%","v":12776.593799999999},{"$f":"AA16-AB16-AC16+AD16","v":116147.0938}]
[]
["SHETG"]
["E45A003A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A19,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":105060},1000,0,{"$f":"(B19-C19-D19)*12.36%","v":12861.815999999999},{"$f":"B19-C19-D19+E19","v":116921.81599999999},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A19,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":102170},1000,0,{"$f":"(G19-H19-I19)*12.36%","v":12504.611999999999},{"$f":"G19-H19-I19+J19","v":113674.61199999999},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A19,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":107520},1000,0,{"$f":"(L19-M19-N19)*12.36%","v":13165.871999999999},{"$f":"L19-M19-N19+O19","v":119685.872},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A19,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":107560},1000,0,{"$f":"(Q19-R19-S19)*12.36%","v":13170.815999999999},{"$f":"Q19-R19-S19+T19","v":119730.81599999999},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A19,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":102320},1000,0,{"$f":"(V19-W19-X19)*12.36%","v":12523.151999999998},{"$f":"V19-W19-X19+Y19","v":113843.152},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A19,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":105590},1000,0,{"$f":"(AA19-AB19-AC19)*12.36%","v":12927.323999999999},{"$f":"AA19-AB19-AC19+AD19","v":117517.32399999999}]
["E45A003OG"]
["EXTR "]
["E52A003A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A22,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":106580},1000,0,{"$f":"(B22-C22-D22)*12.36%","v":13049.687999999998},{"$f":"B22-C22-D22+E22","v":118629.68799999999},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A22,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":104840},1000,0,{"$f":"(G22-H22-I22)*12.36%","v":12834.623999999998},{"$f":"G22-H22-I22+J22","v":116674.624},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A22,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":110190},1000,0,{"$f":"(L22-M22-N22)*12.36%","v":13495.883999999998},{"$f":"L22-M22-N22+O22","v":122685.88399999999},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A22,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":110230},1000,0,{"$f":"(Q22-R22-S22)*12.36%","v":13500.828},{"$f":"Q22-R22-S22+T22","v":122730.82799999999},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A22,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":104990},1000,0,{"$f":"(V22-W22-X22)*12.36%","v":12853.163999999999},{"$f":"V22-W22-X22+Y22","v":116843.164},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A22,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":108190},1000,0,{"$f":"(AA22-AB22-AC22)*12.36%","v":13248.683999999999},{"$f":"AA22-AB22-AC22+AD22","v":120438.68399999999}]
["E52A003OG"]
["E52U003A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A24,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":110360},1000,0,{"$f":"(B24-C24-D24)*12.36%","v":13516.895999999999},{"$f":"B24-C24-D24+E24","v":122876.89599999999},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A24,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":108620},1000,0,{"$f":"(G24-H24-I24)*12.36%","v":13301.831999999999},{"$f":"G24-H24-I24+J24","v":120921.83199999999},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A24,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":113970},1000,0,{"$f":"(L24-M24-N24)*12.36%","v":13963.091999999999},{"$f":"L24-M24-N24+O24","v":126933.092},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A24,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":114010},1000,0,{"$f":"(Q24-R24-S24)*12.36%","v":13968.035999999998},{"$f":"Q24-R24-S24+T24","v":126978.03599999999},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A24,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":108770},1000,0,{"$f":"(V24-W24-X24)*12.36%","v":13320.371999999999},{"$f":"V24-W24-X24+Y24","v":121090.372},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A24,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":111970},1000,0,{"$f":"(AA24-AB24-AC24)*12.36%","v":13715.891999999998},{"$f":"AA24-AB24-AC24+AD24","v":124685.89199999999}]
["E52U003OG"]
["HM FILM"]
["F55HM0003A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A27,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":104850},1000,0,{"$f":"(B27-C27-D27)*12.36%","v":12835.859999999999},{"$f":"B27-C27-D27+E27","v":116685.86},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A27,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":103450},1000,0,{"$f":"(G27-H27-I27)*12.36%","v":12662.819999999998},{"$f":"G27-H27-I27+J27","v":115112.81999999999},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A27,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":108470},1000,0,{"$f":"(L27-M27-N27)*12.36%","v":13283.291999999999},{"$f":"L27-M27-N27+O27","v":120753.292},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A27,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":108520},1000,0,{"$f":"(Q27-R27-S27)*12.36%","v":13289.471999999998},{"$f":"Q27-R27-S27+T27","v":120809.47199999999},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A27,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":104460},1000,0,{"$f":"(V27-W27-X27)*12.36%","v":12787.655999999999},{"$f":"V27-W27-X27+Y27","v":116247.656},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A27,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":106610},1000,0,{"$f":"(AA27-AB27-AC27)*12.36%","v":13053.395999999999},{"$f":"AA27-AB27-AC27+AD27","v":118663.39599999999}]
["F55HM0003OG"]
["IM HIGH"]
["I50A180A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A30,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":101660},1000,0,{"$f":"(B30-C30-D30)*12.36%","v":12441.575999999999},{"$f":"B30-C30-D30+E30","v":113101.576},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A30,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":99760},1000,0,{"$f":"(G30-H30-I30)*12.36%","v":12206.735999999999},{"$f":"G30-H30-I30+J30","v":110966.736},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A30,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":104840},1000,0,{"$f":"(L30-M30-N30)*12.36%","v":12834.623999999998},{"$f":"L30-M30-N30+O30","v":116674.624},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A30,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":104760},1000,0,{"$f":"(Q30-R30-S30)*12.36%","v":12824.735999999999},{"$f":"Q30-R30-S30+T30","v":116584.736},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A30,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":100280},1000,0,{"$f":"(V30-W30-X30)*12.36%","v":12271.007999999998},{"$f":"V30-W30-X30+Y30","v":111551.008},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A30,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":102890},1000,0,{"$f":"(AA30-AB30-AC30)*12.36%","v":12593.603999999999},{"$f":"AA30-AB30-AC30+AD30","v":114483.60399999999}]
["I50A180OG"]
["IM LOW"]
["I60A080A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A33,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":103710},1000,0,{"$f":"(B33-C33-D33)*12.36%","v":12694.955999999998},{"$f":"B33-C33-D33+E33","v":115404.95600000001},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A33,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":100820},1000,0,{"$f":"(G33-H33-I33)*12.36%","v":12337.751999999999},{"$f":"G33-H33-I33+J33","v":112157.75199999999},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A33,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":106170},1000,0,{"$f":"(L33-M33-N33)*12.36%","v":12999.011999999999},{"$f":"L33-M33-N33+O33","v":118169.012},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A33,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":106210},1000,0,{"$f":"(Q33-R33-S33)*12.36%","v":13003.955999999998},{"$f":"Q33-R33-S33+T33","v":118213.95600000001},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A33,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":100970},1000,0,{"$f":"(V33-W33-X33)*12.36%","v":12356.291999999999},{"$f":"V33-W33-X33+Y33","v":112326.292},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A33,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":104190},1000,0,{"$f":"(AA33-AB33-AC33)*12.36%","v":12754.283999999998},{"$f":"AA33-AB33-AC33+AD33","v":115944.284}]
["I60A080OG"]
["IM-L-UV"]
["I60U080A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A36,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":105240},1000,0,{"$f":"(B36-C36-D36)*12.36%","v":12884.063999999998},{"$f":"B36-C36-D36+E36","v":117124.064},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A36,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":102350},1000,0,{"$f":"(G36-H36-I36)*12.36%","v":12526.859999999999},{"$f":"G36-H36-I36+J36","v":113876.86},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A36,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":107700},1000,0,{"$f":"(L36-M36-N36)*12.36%","v":13188.119999999999},{"$f":"L36-M36-N36+O36","v":119888.12},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A36,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":107740},1000,0,{"$f":"(Q36-R36-S36)*12.36%","v":13193.063999999998},{"$f":"Q36-R36-S36+T36","v":119933.064},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A36,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":102500},1000,0,{"$f":"(V36-W36-X36)*12.36%","v":12545.4},{"$f":"V36-W36-X36+Y36","v":114045.4},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A36,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":105690},1000,0,{"$f":"(AA36-AB36-AC36)*12.36%","v":12939.683999999999},{"$f":"AA36-AB36-AC36+AD36","v":117629.68399999999}]
["I60U080OG"]
["PIPE (PE80)"]
["P54A001A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A39,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":113570},1000,0,{"$f":"(B39-C39-D39)*12.36%","v":13913.651999999998},{"$f":"B39-C39-D39+E39","v":126483.652},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A39,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":110160},1000,0,{"$f":"(G39-H39-I39)*12.36%","v":13492.175999999999},{"$f":"G39-H39-I39+J39","v":122652.17600000001},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A39,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":115180},1000,0,{"$f":"(L39-M39-N39)*12.36%","v":14112.647999999999},{"$f":"L39-M39-N39+O39","v":128292.648},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A39,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":115230},1000,0,{"$f":"(Q39-R39-S39)*12.36%","v":14118.827999999998},{"$f":"Q39-R39-S39+T39","v":128348.82799999999},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A39,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":111230},1000,0,{"$f":"(V39-W39-X39)*12.36%","v":13624.427999999998},{"$f":"V39-W39-X39+Y39","v":123854.428},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A39,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":113320},1000,0,{"$f":"(AA39-AB39-AC39)*12.36%","v":13882.751999999999},{"$f":"AA39-AB39-AC39+AD39","v":126202.75199999999}]
["P54A001OG"]
["PIPE (PE100)"]
["P52A003A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":115580},1000,0,{"$f":"(B42-C42-D42)*12.36%","v":14162.087999999998},{"$f":"B42-C42-D42+E42","v":128742.088},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":112160},1000,0,{"$f":"(G42-H42-I42)*12.36%","v":13739.375999999998},{"$f":"G42-H42-I42+J42","v":124899.376},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":117180},1000,0,{"$f":"(L42-M42-N42)*12.36%","v":14359.847999999998},{"$f":"L42-M42-N42+O42","v":130539.848},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":117230},1000,0,{"$f":"(Q42-R42-S42)*12.36%","v":14366.027999999998},{"$f":"Q42-R42-S42+T42","v":130596.02799999999},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":113240},1000,0,{"$f":"(V42-W42-X42)*12.36%","v":13872.863999999998},{"$f":"V42-W42-X42+Y42","v":126112.864},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":115320},1000,0,{"$f":"(AA42-AB42-AC42)*12.36%","v":14129.951999999999},{"$f":"AA42-AB42-AC42+AD42","v":128449.952}]
["RAFFIA"]
["W50A009A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":106430},1000,0,{"$f":"(B44-C44-D44)*12.36%","v":13031.147999999999},{"$f":"B44-C44-D44+E44","v":118461.148},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":103940},1000,0,{"$f":"(G44-H44-I44)*12.36%","v":12723.383999999998},{"$f":"G44-H44-I44+J44","v":115663.38399999999},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":109290},1000,0,{"$f":"(L44-M44-N44)*12.36%","v":13384.643999999998},{"$f":"L44-M44-N44+O44","v":121674.644},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":109330},1000,0,{"$f":"(Q44-R44-S44)*12.36%","v":13389.587999999998},{"$f":"Q44-R44-S44+T44","v":121719.588},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":104090},1000,0,{"$f":"(V44-W44-X44)*12.36%","v":12741.923999999999},{"$f":"V44-W44-X44+Y44","v":115831.924},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A44,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":107190},1000,0,{"$f":"(AA44-AB44-AC44)*12.36%","v":13125.083999999999},{"$f":"AA44-AB44-AC44+AD44","v":119315.084}]
["T50A010A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":106430},1000,0,{"$f":"(B45-C45-D45)*12.36%","v":13031.147999999999},{"$f":"B45-C45-D45+E45","v":118461.148},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":103940},1000,0,{"$f":"(G45-H45-I45)*12.36%","v":12723.383999999998},{"$f":"G45-H45-I45+J45","v":115663.38399999999},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":109290},1000,0,{"$f":"(L45-M45-N45)*12.36%","v":13384.643999999998},{"$f":"L45-M45-N45+O45","v":121674.644},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":109330},1000,0,{"$f":"(Q45-R45-S45)*12.36%","v":13389.587999999998},{"$f":"Q45-R45-S45+T45","v":121719.588},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":104590},1000,0,{"$f":"(V45-W45-X45)*12.36%","v":12803.723999999998},{"$f":"V45-W45-X45+Y45","v":116393.724},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":107190},1000,0,{"$f":"(AA45-AB45-AC45)*12.36%","v":13125.083999999999},{"$f":"AA45-AB45-AC45+AD45","v":119315.084}]
["MF"]
["W52A009A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":103330},1000,0,{"$f":"(B47-C47-D47)*12.36%","v":12647.987999999999},{"$f":"B47-C47-D47+E47","v":114977.988},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":100440},1000,0,{"$f":"(G47-H47-I47)*12.36%","v":12290.784},{"$f":"G47-H47-I47+J47","v":111730.784},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":105790},1000,0,{"$f":"(L47-M47-N47)*12.36%","v":12952.043999999998},{"$f":"L47-M47-N47+O47","v":117742.04399999999},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":105830},1000,0,{"$f":"(Q47-R47-S47)*12.36%","v":12956.987999999999},{"$f":"Q47-R47-S47+T47","v":117786.988},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":100590},1000,0,{"$f":"(V47-W47-X47)*12.36%","v":12309.323999999999},{"$f":"V47-W47-X47+Y47","v":111899.32399999999},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":103690},1000,0,{"$f":"(AA47-AB47-AC47)*12.36%","v":12692.483999999999},{"$f":"AA47-AB47-AC47+AD47","v":115382.484}]
["W52A009OG"]
["W52ASR009A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":103330},1000,0,{"$f":"(B49-C49-D49)*12.36%","v":12647.987999999999},{"$f":"B49-C49-D49+E49","v":114977.988},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":100440},1000,0,{"$f":"(G49-H49-I49)*12.36%","v":12290.784},{"$f":"G49-H49-I49+J49","v":111730.784},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":105790},1000,0,{"$f":"(L49-M49-N49)*12.36%","v":12952.043999999998},{"$f":"L49-M49-N49+O49","v":117742.04399999999},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":105830},1000,0,{"$f":"(Q49-R49-S49)*12.36%","v":12956.987999999999},{"$f":"Q49-R49-S49+T49","v":117786.988},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":100590},1000,0,{"$f":"(V49-W49-X49)*12.36%","v":12309.323999999999},{"$f":"V49-W49-X49+Y49","v":111899.32399999999},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A49,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":103690},1000,0,{"$f":"(AA49-AB49-AC49)*12.36%","v":12692.483999999999},{"$f":"AA49-AB49-AC49+AD49","v":115382.484}]
["W55A004A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":106330},1000,0,{"$f":"(B50-C50-D50)*12.36%","v":13018.787999999999},{"$f":"B50-C50-D50+E50","v":118348.788},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":103440},1000,0,{"$f":"(G50-H50-I50)*12.36%","v":12661.583999999999},{"$f":"G50-H50-I50+J50","v":115101.584},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":108790},1000,0,{"$f":"(L50-M50-N50)*12.36%","v":13322.843999999999},{"$f":"L50-M50-N50+O50","v":121112.844},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":108830},1000,0,{"$f":"(Q50-R50-S50)*12.36%","v":13327.787999999999},{"$f":"Q50-R50-S50+T50","v":121157.788},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":103590},1000,0,{"$f":"(V50-W50-X50)*12.36%","v":12680.123999999998},{"$f":"V50-W50-X50+Y50","v":115270.124},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":106690},1000,0,{"$f":"(AA50-AB50-AC50)*12.36%","v":13063.283999999998},{"$f":"AA50-AB50-AC50+AD50","v":118753.284}]
["LLDPE"]
["E20AN009A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":106800},1000,0,{"$f":"(B52-C52-D52)*12.36%","v":13076.88},{"$f":"B52-C52-D52+E52","v":118876.88},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":105210},1000,0,{"$f":"(G52-H52-I52)*12.36%","v":12880.355999999998},{"$f":"G52-H52-I52+J52","v":117090.356},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":110560},1000,0,{"$f":"(L52-M52-N52)*12.36%","v":13541.615999999998},{"$f":"L52-M52-N52+O52","v":123101.61599999999},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":110600},1000,0,{"$f":"(Q52-R52-S52)*12.36%","v":13546.56},{"$f":"Q52-R52-S52+T52","v":123146.56},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":105360},1000,0,{"$f":"(V52-W52-X52)*12.36%","v":12898.895999999999},{"$f":"V52-W52-X52+Y52","v":117258.89599999999},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":108590},1000,0,{"$f":"(AA52-AB52-AC52)*12.36%","v":13298.123999999998},{"$f":"AA52-AB52-AC52+AD52","v":120888.124}]
["E20AN009OG"]
["E36A060A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":111440},1000,0,{"$f":"(B54-C54-D54)*12.36%","v":13650.383999999998},{"$f":"B54-C54-D54+E54","v":124090.38399999999},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":108250},1000,0,{"$f":"(G54-H54-I54)*12.36%","v":13256.099999999999},{"$f":"G54-H54-I54+J54","v":120506.1},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":113600},1000,0,{"$f":"(L54-M54-N54)*12.36%","v":13917.359999999999},{"$f":"L54-M54-N54+O54","v":126517.36},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":113640},1000,0,{"$f":"(Q54-R54-S54)*12.36%","v":13922.303999999998},{"$f":"Q54-R54-S54+T54","v":126562.304},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":108400},1000,0,{"$f":"(V54-W54-X54)*12.36%","v":13274.64},{"$f":"V54-W54-X54+Y54","v":120674.64},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A54,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":111590},1000,0,{"$f":"(AA54-AB54-AC54)*12.36%","v":13668.923999999999},{"$f":"AA54-AB54-AC54+AD54","v":124258.924}]
["E36A060OG"]
["FILM"]
["F20S009A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":108300},1000,0,{"$f":"(B57-C57-D57)*12.36%","v":13262.279999999999},{"$f":"B57-C57-D57+E57","v":120562.28},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":106710},1000,0,{"$f":"(G57-H57-I57)*12.36%","v":13065.755999999999},{"$f":"G57-H57-I57+J57","v":118775.75599999999},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":112060},1000,0,{"$f":"(L57-M57-N57)*12.36%","v":13727.015999999998},{"$f":"L57-M57-N57+O57","v":124787.016},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":112100},1000,0,{"$f":"(Q57-R57-S57)*12.36%","v":13731.96},{"$f":"Q57-R57-S57+T57","v":124831.95999999999},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":106860},1000,0,{"$f":"(V57-W57-X57)*12.36%","v":13084.295999999998},{"$f":"V57-W57-X57+Y57","v":118944.296},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":110090},1000,0,{"$f":"(AA57-AB57-AC57)*12.36%","v":13483.523999999999},{"$f":"AA57-AB57-AC57+AD57","v":122573.524}]
["F20S009OG"]
["D22S010A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":107300},1000,0,{"$f":"(B59-C59-D59)*12.36%","v":13138.679999999998},{"$f":"B59-C59-D59+E59","v":119438.68},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":105710},1000,0,{"$f":"(G59-H59-I59)*12.36%","v":12942.155999999999},{"$f":"G59-H59-I59+J59","v":117652.156},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":111060},1000,0,{"$f":"(L59-M59-N59)*12.36%","v":13603.415999999999},{"$f":"L59-M59-N59+O59","v":123663.416},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":111100},1000,0,{"$f":"(Q59-R59-S59)*12.36%","v":13608.359999999999},{"$f":"Q59-R59-S59+T59","v":123708.36},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":105860},1000,0,{"$f":"U59-V59-W59+X59","v":16848.36},{"$f":"V59-W59-X59+Y59","v":121708.36},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":109090},1000,0,{"$f":"(AA59-AB59-AC59)*12.36%","v":13359.923999999999},{"$f":"AA59-AB59-AC59+AD59","v":121449.924}]
["ROTO"]
["R35A042A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":109220},1000,0,{"$f":"(B61-C61-D61)*12.36%","v":13375.991999999998},{"$f":"B61-C61-D61+E61","v":121595.992},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":105200},1000,0,{"$f":"(G61-H61-I61)*12.36%","v":12879.119999999999},{"$f":"G61-H61-I61+J61","v":117079.12},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":110570},1000,0,{"$f":"(L61-M61-N61)*12.36%","v":13542.851999999999},{"$f":"L61-M61-N61+O61","v":123112.852},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":110620},1000,0,{"$f":"(Q61-R61-S61)*12.36%","v":13549.031999999999},{"$f":"Q61-R61-S61+T61","v":123169.03200000001},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":105870},1000,0,{"$f":"(V61-W61-X61)*12.36%","v":12961.931999999999},{"$f":"V61-W61-X61+Y61","v":117831.932},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A61,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":108710},1000,0,{"$f":"(AA61-AB61-AC61)*12.36%","v":13312.955999999998},{"$f":"AA61-AB61-AC61+AD61","v":121022.95600000001}]
["R35U042A",{"$f":"IF(D$9=\"BARJORA\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,18,0))","v":110500},1000,0,{"$f":"(B62-C62-D62)*12.36%","v":13534.199999999999},{"$f":"B62-C62-D62+E62","v":123034.2},{"$f":"IF(G$9=\"HOSUR\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,19,0))","v":106060},1000,0,{"$f":"(G62-H62-I62)*12.36%","v":12985.415999999999},{"$f":"G62-H62-I62+J62","v":118045.416},{"$f":"IF(L$9=\"JAMMU\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,20,0))","v":111430},1000,0,{"$f":"(L62-M62-N62)*12.36%","v":13649.147999999999},{"$f":"L62-M62-N62+O62","v":124079.148},{"$f":"IF(Q$9=\"NOIDA\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,21,0))","v":111880},1000,null,{"$f":"(Q62-R62-S62)*12.36%","v":13704.767999999998},{"$f":"Q62-R62-S62+T62","v":124584.768},{"$f":"IF(V$9=\"PONDICHERRY\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,22,0))","v":106750},1000,0,{"$f":"(V62-W62-X62)*12.36%","v":13070.699999999999},{"$f":"V62-W62-X62+Y62","v":118820.7},{"$f":"IF(AA$9=\"BARODA\",HLOOKUP($A62,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,23,0))","v":109570},1000,0,{"$f":"(AA62-AB62-AC62)*12.36%","v":13419.251999999999},{"$f":"AA62-AB62-AC62+AD62","v":121989.25199999999}]
[]
["NOTE:","LOCATION DISCOUNT HAS BEEN DISCONTINUED"]
[]
[null," THE PRICES OF OLD PLANT & NEW PLANT  ARE SAME FROM DIRECT SALE"]

{"sheet":"Sheet4","index":3,"n_rows":64,"n_cols":26,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,0,0,25],[1,0,1,25],[2,0,2,25],[3,0,3,25],[4,0,4,25],[5,0,5,25],[7,1,7,5],[7,6,7,10],[7,11,7,15],[7,16,7,20],[7,21,7,25]]}
["UNITED BROTHERS"]
["CONSIGNMENT STOCKIST OF GAIL (INDIA) LTD"]
["301,HERITAGE PLAZA, R.S.MAHARAJ MARG,( TELI GALLI CROSS LANE), ANDHERI (E), MUMBAI - 400 069"]
[" TEL:  26844612(4 LINES) FAX: 26822914  E-MAIL: info@unibrothers.com ,prashant@unibrothers.com ,jyoti@unibrothers.com"]
["EX-WORKS PRICE OF HDPE \"G-LEX / G-LENE \" W.E.F. 1ST MAY 2014"]
["CASH / ADVANCE PAYMENT FOR MAHARASHTRA & DAMAN"]
[null,"                Freight  985.53",null,null,null,null,"                            Freight   3199.90",null,null,null,null,"                      ",null,"FREIGHT 1758.96",null,null,null,"FREIGHT 5424.7",null,null,null,"            Freight  2024.85"]
[null,"ALWAR",null,null,null,null,"HYDERABAD",null,null,null,null,"BADDI",null,null,null,null,"UDMALPET",null,null,null,null,"BHAVNAGAR"]
[null,"BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS","BASIC","DISC","LOC","EXCISE","EX-WKS",null,"DISC","LOC","EXCISE","EX-WKS"]
["BM"]
["B52A003A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A11,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":108970},1000,0,{"$f":"(B11-C11-D11)*12.36%","v":13345.091999999999},{"$f":"B11-C11-D11+E11","v":121315.092},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A11,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":105900},1000,0,{"$f":"(G11-H11-I11)*12.36%","v":12965.64},{"$f":"G11-H11-I11+J11","v":117865.64},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A11,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":108520},1000,0,{"$f":"(L11-M11-N11)*12.36%","v":13289.471999999998},{"$f":"L11-M11-N11+O11","v":120809.47199999999},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A11,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":103710},1000,0,{"$f":"(Q11-R11-S11)*12.36%","v":12694.955999999998},{"$f":"Q11-R11-S11+T11","v":115404.95600000001},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A11,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":107110},1000,0,{"$f":"(V11-W11-X11)*12.36%","v":13115.195999999998},{"$f":"V11-W11-X11+Y11","v":119225.196}]
["B63A003A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":108970},1000,0,{"$f":"(B12-C12-D12)*12.36%","v":13345.091999999999},{"$f":"B12-C12-D12+E12","v":121315.092},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":105900},1000,0,{"$f":"(G12-H12-I12)*12.36%","v":12965.64},{"$f":"G12-H12-I12+J12","v":117865.64},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":108520},1000,0,{"$f":"(L12-M12-N12)*12.36%","v":13289.471999999998},{"$f":"L12-M12-N12+O12","v":120809.47199999999},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":103710},1000,0,{"$f":"(Q12-R12-S12)*12.36%","v":12694.955999999998},{"$f":"Q12-R12-S12+T12","v":115404.95600000001},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A12,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":107110},1000,0,{"$f":"(V12-W12-X12)*12.36%","v":13115.195999999998},{"$f":"V12-W12-X12+Y12","v":119225.196}]
["B55HM0003A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":113170},1000,0,{"$f":"(B13-C13-D13)*12.36%","v":13864.211999999998},{"$f":"B13-C13-D13+E13","v":126034.212},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":109940},1000,0,{"$f":"(G13-H13-I13)*12.36%","v":13464.983999999999},{"$f":"G13-H13-I13+J13","v":122404.984},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":113180},1000,0,{"$f":"(L13-M13-N13)*12.36%","v":13865.447999999999},{"$f":"L13-M13-N13+O13","v":126045.448},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":107860},1000,0,{"$f":"(Q13-R13-S13)*12.36%","v":13207.895999999999},{"$f":"Q13-R13-S13+T13","v":120067.89599999999},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A13,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":110970},1000,0,{"$f":"(V13-W13-X13)*12.36%","v":13592.291999999999},{"$f":"V13-W13-X13+Y13","v":123562.292}]
["CABLE-INSUL"]
["C43D006A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A15,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":106593.5},1000,0,{"$f":"(B15-C15-D15)*12.36%","v":13051.356599999999},{"$f":"B15-C15-D15+E15","v":118644.8566},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A15,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":103487},1000,0,{"$f":"(G15-H15-I15)*12.36%","v":12667.393199999999},{"$f":"G15-H15-I15+J15","v":115154.39319999999},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A15,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":106641},1000,0,{"$f":"(L15-M15-N15)*12.36%","v":13057.227599999998},{"$f":"L15-M15-N15+O15","v":118698.2276},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A15,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":101321},1000,0,{"$f":"(Q15-R15-S15)*12.36%","v":12399.675599999999},{"$f":"Q15-R15-S15+T15","v":112720.6756},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A15,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":104285},1000,0,{"$f":"(V15-W15-X15)*12.36%","v":12766.025999999998},{"$f":"V15-W15-X15+Y15","v":116051.026}]
[]
["SHETG"]
["E45A003A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A18,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":107780},1000,0,{"$f":"(B18-C18-D18)*12.36%","v":13198.007999999998},{"$f":"B18-C18-D18+E18","v":119978.008},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A18,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":104510},1000,0,{"$f":"(G18-H18-I18)*12.36%","v":12793.835999999999},{"$f":"G18-H18-I18+J18","v":116303.836},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A18,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":107830},1000,0,{"$f":"(L18-M18-N18)*12.36%","v":13204.187999999998},{"$f":"L18-M18-N18+O18","v":120034.18799999999},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A18,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":102220},1000,0,{"$f":"(Q18-R18-S18)*12.36%","v":12510.791999999999},{"$f":"Q18-R18-S18+T18","v":113730.792},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A18,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":105500},1000,0,{"$f":"(V18-W18-X18)*12.36%","v":12916.199999999999},{"$f":"V18-W18-X18+Y18","v":117416.2}]
["E45A003OG"]
["EXTR "]
["E52A003A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A21,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":110450},1000,0,{"$f":"(B21-C21-D21)*12.36%","v":13528.019999999999},{"$f":"B21-C21-D21+E21","v":122978.02},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A21,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":107180},1000,0,{"$f":"(G21-H21-I21)*12.36%","v":13123.847999999998},{"$f":"G21-H21-I21+J21","v":119303.848},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A21,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":110500},1000,0,{"$f":"(L21-M21-N21)*12.36%","v":13534.199999999999},{"$f":"L21-M21-N21+O21","v":123034.2},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A21,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":104890},1000,0,{"$f":"(Q21-R21-S21)*12.36%","v":12840.803999999998},{"$f":"Q21-R21-S21+T21","v":116730.804},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A21,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":108100},1000,0,{"$f":"(V21-W21-X21)*12.36%","v":13237.56},{"$f":"V21-W21-X21+Y21","v":120337.56}]
["E52A003OG"]
["E52U003A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":114230},1000,0,{"$f":"(B23-C23-D23)*12.36%","v":13995.227999999999},{"$f":"B23-C23-D23+E23","v":127225.228},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":110960},1000,0,{"$f":"(G23-H23-I23)*12.36%","v":13591.055999999999},{"$f":"G23-H23-I23+J23","v":123551.056},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":114280},1000,0,{"$f":"(L23-M23-N23)*12.36%","v":14001.407999999999},{"$f":"L23-M23-N23+O23","v":127281.408},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":108670},1000,0,{"$f":"(Q23-R23-S23)*12.36%","v":13308.011999999999},{"$f":"Q23-R23-S23+T23","v":120978.012},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A23,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":111880},1000,0,{"$f":"(V23-W23-X23)*12.36%","v":13704.767999999998},{"$f":"V23-W23-X23+Y23","v":124584.768}]
["E52U003OG"]
["HM FILM"]
["F55HM0003A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A26,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":108720},1000,0,{"$f":"(B26-C26-D26)*12.36%","v":13314.191999999999},{"$f":"B26-C26-D26+E26","v":121034.192},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A26,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":104240},1000,0,{"$f":"(G26-H26-I26)*12.36%","v":12760.463999999998},{"$f":"G26-H26-I26+J26","v":116000.46399999999},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A26,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":107980},1000,0,{"$f":"(L26-M26-N26)*12.36%","v":13222.727999999999},{"$f":"L26-M26-N26+O26","v":120202.728},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A26,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":103410},1000,0,{"$f":"(Q26-R26-S26)*12.36%","v":12657.875999999998},{"$f":"Q26-R26-S26+T26","v":115067.876},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A26,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":106520},1000,0,{"$f":"(V26-W26-X26)*12.36%","v":13042.271999999999},{"$f":"V26-W26-X26+Y26","v":118562.272}]
["F55HM0003OG"]
["IM HIGH"]
["I50A180A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A29,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":104950},1000,0,{"$f":"(B29-C29-D29)*12.36%","v":12848.22},{"$f":"B29-C29-D29+E29","v":116798.22},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A29,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":101930},1000,0,{"$f":"(G29-H29-I29)*12.36%","v":12474.947999999999},{"$f":"G29-H29-I29+J29","v":113404.948},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A29,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":104520},1000,0,{"$f":"(L29-M29-N29)*12.36%","v":12795.071999999998},{"$f":"L29-M29-N29+O29","v":116315.072},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A29,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":99920},1000,0,{"$f":"(Q29-R29-S29)*12.36%","v":12226.511999999999},{"$f":"Q29-R29-S29+T29","v":111146.512},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A29,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":102850},1000,0,{"$f":"(V29-W29-X29)*12.36%","v":12588.659999999998},{"$f":"V29-W29-X29+Y29","v":114438.66}]
["I50A180OG"]
["IM LOW"]
["I60A080A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A32,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":106420},1000,0,{"$f":"(B32-C32-D32)*12.36%","v":13029.911999999998},{"$f":"B32-C32-D32+E32","v":118449.912},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A32,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":103150},1000,0,{"$f":"(G32-H32-I32)*12.36%","v":12625.739999999998},{"$f":"G32-H32-I32+J32","v":114775.73999999999},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A32,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":106480},1000,0,{"$f":"(L32-M32-N32)*12.36%","v":13037.328},{"$f":"L32-M32-N32+O32","v":118517.32799999999},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A32,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":100870},1000,0,{"$f":"(Q32-R32-S32)*12.36%","v":12343.931999999999},{"$f":"Q32-R32-S32+T32","v":112213.932},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A32,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":104100},1000,0,{"$f":"(V32-W32-X32)*12.36%","v":12743.159999999998},{"$f":"V32-W32-X32+Y32","v":115843.16}]
["I60A080OG"]
["IM-L-UV"]
["I60U080A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A35,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":107960},1000,0,{"$f":"(B35-C35-D35)*12.36%","v":13220.255999999999},{"$f":"B35-C35-D35+E35","v":120180.25599999999},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A35,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":104690},1000,0,{"$f":"(G35-H35-I35)*12.36%","v":12816.083999999999},{"$f":"G35-H35-I35+J35","v":116506.084},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A35,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":108010},1000,0,{"$f":"(L35-M35-N35)*12.36%","v":13226.435999999998},{"$f":"L35-M35-N35+O35","v":120236.436},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A35,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":102410},1000,0,{"$f":"(Q35-R35-S35)*12.36%","v":12534.275999999998},{"$f":"Q35-R35-S35+T35","v":113944.276},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A35,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":105600},1000,0,{"$f":"(V35-W35-X35)*12.36%","v":12928.56},{"$f":"V35-W35-X35+Y35","v":117528.56}]
["I60U080OG"]
["PIPE (PE80)"]
["P54A001A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A38,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":115430},1000,0,{"$f":"(B38-C38-D38)*12.36%","v":14143.547999999999},{"$f":"B38-C38-D38+E38","v":128573.548},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A38,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":112200},1000,0,{"$f":"(G38-H38-I38)*12.36%","v":13744.319999999998},{"$f":"G38-H38-I38+J38","v":124944.31999999999},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A38,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":115440},1000,0,{"$f":"(L38-M38-N38)*12.36%","v":14144.783999999998},{"$f":"L38-M38-N38+O38","v":128584.784},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A38,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":110120},1000,0,{"$f":"(Q38-R38-S38)*12.36%","v":13487.231999999998},{"$f":"Q38-R38-S38+T38","v":122607.232},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A38,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":113230},1000,0,{"$f":"(V38-W38-X38)*12.36%","v":13871.627999999999},{"$f":"V38-W38-X38+Y38","v":126101.628}]
["PIPE (PE100)"]
["P52A003A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":117430},1000,0,{"$f":"(B40-C40-D40)*12.36%","v":14390.747999999998},{"$f":"B40-C40-D40+E40","v":130820.74799999999},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":114200},1000,0,{"$f":"(G40-H40-I40)*12.36%","v":13991.519999999999},{"$f":"G40-H40-I40+J40","v":127191.52},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":117440},1000,0,{"$f":"(L40-M40-N40)*12.36%","v":14391.983999999999},{"$f":"L40-M40-N40+O40","v":130831.984},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":112120},1000,0,{"$f":"(Q40-R40-S40)*12.36%","v":13734.431999999999},{"$f":"Q40-R40-S40+T40","v":124854.432},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A40,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":115230},1000,0,{"$f":"(V40-W40-X40)*12.36%","v":14118.827999999998},{"$f":"V40-W40-X40+Y40","v":128348.82799999999}]
["RAFFIA"]
["W50A009A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":109550},1000,0,{"$f":"(B42-C42-D42)*12.36%","v":13416.779999999999},{"$f":"B42-C42-D42+E42","v":121966.78},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":106280},1000,0,{"$f":"(G42-H42-I42)*12.36%","v":13012.607999999998},{"$f":"G42-H42-I42+J42","v":118292.60799999999},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":109600},1000,0,{"$f":"(L42-M42-N42)*12.36%","v":13422.96},{"$f":"L42-M42-N42+O42","v":122022.95999999999},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":104000},1000,0,{"$f":"(Q42-R42-S42)*12.36%","v":12730.8},{"$f":"Q42-R42-S42+T42","v":115730.8},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A42,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":107100},1000,0,{"$f":"(V42-W42-X42)*12.36%","v":13113.96},{"$f":"V42-W42-X42+Y42","v":119213.95999999999}]
["T50A010A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A43,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":110050},1000,0,{"$f":"(B43-C43-D43)*12.36%","v":13478.579999999998},{"$f":"B43-C43-D43+E43","v":122528.58},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A43,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":106280},1000,0,{"$f":"(G43-H43-I43)*12.36%","v":13012.607999999998},{"$f":"G43-H43-I43+J43","v":118292.60799999999},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A43,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":109600},1000,0,{"$f":"(L43-M43-N43)*12.36%","v":13422.96},{"$f":"L43-M43-N43+O43","v":122022.95999999999},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A43,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":104500},1000,0,{"$f":"(Q43-R43-S43)*12.36%","v":12792.599999999999},{"$f":"Q43-R43-S43+T43","v":116292.6},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A43,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":107100},1000,0,{"$f":"(V43-W43-X43)*12.36%","v":13113.96},{"$f":"V43-W43-X43+Y43","v":119213.95999999999}]
["MF"]
["W52A009A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":106050},1000,0,{"$f":"(B45-C45-D45)*12.36%","v":12984.179999999998},{"$f":"B45-C45-D45+E45","v":118034.18},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":102780},1000,0,{"$f":"(G45-H45-I45)*12.36%","v":12580.007999999998},{"$f":"G45-H45-I45+J45","v":114360.008},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":106100},1000,0,{"$f":"(L45-M45-N45)*12.36%","v":12990.359999999999},{"$f":"L45-M45-N45+O45","v":118090.36},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":100500},1000,0,{"$f":"(Q45-R45-S45)*12.36%","v":12298.199999999999},{"$f":"Q45-R45-S45+T45","v":111798.2},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A45,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":103600},1000,0,{"$f":"(V45-W45-X45)*12.36%","v":12681.359999999999},{"$f":"V45-W45-X45+Y45","v":115281.36}]
["W52A009OG"]
["W52ASR009A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":106050},1000,0,{"$f":"(B47-C47-D47)*12.36%","v":12984.179999999998},{"$f":"B47-C47-D47+E47","v":118034.18},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":102780},1000,0,{"$f":"(G47-H47-I47)*12.36%","v":12580.007999999998},{"$f":"G47-H47-I47+J47","v":114360.008},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":106100},1000,0,{"$f":"(L47-M47-N47)*12.36%","v":12990.359999999999},{"$f":"L47-M47-N47+O47","v":118090.36},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":100500},1000,0,{"$f":"(Q47-R47-S47)*12.36%","v":12298.199999999999},{"$f":"Q47-R47-S47+T47","v":111798.2},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A47,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":103600},1000,0,{"$f":"(V47-W47-X47)*12.36%","v":12681.359999999999},{"$f":"V47-W47-X47+Y47","v":115281.36}]
["W55A004A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A48,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":109050},1000,0,{"$f":"(B48-C48-D48)*12.36%","v":13354.98},{"$f":"B48-C48-D48+E48","v":121404.98},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A48,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":105780},1000,0,{"$f":"(G48-H48-I48)*12.36%","v":12950.807999999999},{"$f":"G48-H48-I48+J48","v":117730.808},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A48,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":109100},1000,0,{"$f":"(L48-M48-N48)*12.36%","v":13361.159999999998},{"$f":"L48-M48-N48+O48","v":121461.16},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A48,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":103500},1000,0,{"$f":"(Q48-R48-S48)*12.36%","v":12668.999999999998},{"$f":"Q48-R48-S48+T48","v":115169},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A48,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":106600},1000,0,{"$f":"(V48-W48-X48)*12.36%","v":13052.159999999998},{"$f":"V48-W48-X48+Y48","v":118652.16}]
["LLDPE"]
["E20AN009A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":110810},1000,0,{"$f":"(B50-C50-D50)*12.36%","v":13572.515999999998},{"$f":"B50-C50-D50+E50","v":123382.516},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":107540},1000,0,{"$f":"(G50-H50-I50)*12.36%","v":13168.343999999999},{"$f":"G50-H50-I50+J50","v":119708.344},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":110860},1000,0,{"$f":"(L50-M50-N50)*12.36%","v":13578.695999999998},{"$f":"L50-M50-N50+O50","v":123438.696},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":105260},1000,0,{"$f":"(Q50-R50-S50)*12.36%","v":12886.535999999998},{"$f":"Q50-R50-S50+T50","v":117146.53599999999},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A50,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":108500},1000,0,{"$f":"(V50-W50-X50)*12.36%","v":13286.999999999998},{"$f":"V50-W50-X50+Y50","v":120787}]
["E20AN009OG"]
["E36A060A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":113850},1000,0,{"$f":"(B52-C52-D52)*12.36%","v":13948.259999999998},{"$f":"B52-C52-D52+E52","v":126798.26},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":110580},1000,0,{"$f":"(G52-H52-I52)*12.36%","v":13544.087999999998},{"$f":"G52-H52-I52+J52","v":123124.088},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":113910},1000,0,{"$f":"(L52-M52-N52)*12.36%","v":13955.675999999999},{"$f":"L52-M52-N52+O52","v":126865.67600000001},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":108300},1000,0,{"$f":"(Q52-R52-S52)*12.36%","v":13262.279999999999},{"$f":"Q52-R52-S52+T52","v":120562.28},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A52,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":111500},1000,0,{"$f":"(V52-W52-X52)*12.36%","v":13657.8},{"$f":"V52-W52-X52+Y52","v":124157.8}]
["E36A060OG"]
["FILM"]
["F20S009A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A55,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":112310},1000,0,{"$f":"(B55-C55-D55)*12.36%","v":13757.915999999999},{"$f":"B55-C55-D55+E55","v":125067.916},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A55,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":109040},1000,0,{"$f":"(G55-H55-I55)*12.36%","v":13353.743999999999},{"$f":"G55-H55-I55+J55","v":121393.74400000001},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A55,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":112360},1000,0,{"$f":"(L55-M55-N55)*12.36%","v":13764.095999999998},{"$f":"L55-M55-N55+O55","v":125124.09599999999},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A55,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":106760},1000,0,{"$f":"(Q55-R55-S55)*12.36%","v":13071.935999999998},{"$f":"Q55-R55-S55+T55","v":118831.936},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A55,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":110000},1000,0,{"$f":"(V55-W55-X55)*12.36%","v":13472.399999999998},{"$f":"V55-W55-X55+Y55","v":122472.4}]
["F20S009OG"]
["D22S010A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":111310},1000,0,{"$f":"(B57-C57-D57)*12.36%","v":13634.315999999999},{"$f":"B57-C57-D57+E57","v":123944.31599999999},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":108040},1000,0,{"$f":"(G57-H57-I57)*12.36%","v":13230.143999999998},{"$f":"G57-H57-I57+J57","v":120270.144},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":111360},1000,0,{"$f":"(L57-M57-N57)*12.36%","v":13640.495999999999},{"$f":"L57-M57-N57+O57","v":124000.496},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":105760},1000,0,{"$f":"(Q57-R57-S57)*12.36%","v":12948.335999999999},{"$f":"Q57-R57-S57+T57","v":117708.336},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A57,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":109000},1000,0,{"$f":"(V57-W57-X57)*12.36%","v":13348.8},{"$f":"V57-W57-X57+Y57","v":121348.8}]
["ROTO"]
["R35A042A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":110820},1000,0,{"$f":"(B59-C59-D59)*12.36%","v":13573.751999999999},{"$f":"B59-C59-D59+E59","v":123393.75199999999},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":107590},1000,0,{"$f":"(G59-H59-I59)*12.36%","v":13174.523999999999},{"$f":"G59-H59-I59+J59","v":119764.524},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":110830},1000,0,{"$f":"(L59-M59-N59)*12.36%","v":13574.987999999999},{"$f":"L59-M59-N59+O59","v":123404.988},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":105360},1000,0,{"$f":"(Q59-R59-S59)*12.36%","v":12898.895999999999},{"$f":"Q59-R59-S59+T59","v":117258.89599999999},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A59,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":108620},1000,0,{"$f":"(V59-W59-X59)*12.36%","v":13301.831999999999},{"$f":"V59-W59-X59+Y59","v":120921.83199999999}]
["R35U042A",{"$f":"IF(B$8=\"ALWAR\",HLOOKUP($A60,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,24,0))","v":111680},1000,0,{"$f":"(B60-C60-D60)*12.36%","v":13680.047999999999},{"$f":"B60-C60-D60+E60","v":124360.048},{"$f":"IF(G$8=\"HYDERABAD\",HLOOKUP($A60,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,25,0))","v":108450},1000,0,{"$f":"(G60-H60-I60)*12.36%","v":13280.819999999998},{"$f":"G60-H60-I60+J60","v":120730.81999999999},{"$f":"IF(L$8=\"BADDI\",HLOOKUP($A60,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,26,0))","v":111690},1000,0,{"$f":"(L60-M60-N60)*12.36%","v":13681.283999999998},{"$f":"L60-M60-N60+O60","v":124371.284},{"$f":"IF(Q$8=\"UDMALPET\",HLOOKUP($A60,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,27,0))","v":106220},1000,0,{"$f":"(Q60-R60-S60)*12.36%","v":13005.191999999999},{"$f":"Q60-R60-S60+T60","v":118225.192},{"$f":"IF(V$8=\"BHAVNAGAR\",HLOOKUP($A60,'[2]PROPOSED GAIL EX WORKS'!$D$2:$AE$90,28,0))","v":109480},1000,0,{"$f":"(V60-W60-X60)*12.36%","v":13408.127999999999},{"$f":"V60-W60-X60+Y60","v":121888.128}]
[]
["NOTE:","LOCATION DISCOUNT HAS BEEN DISCONTINUED"]
[]
[null," THE PRICES OF OLD PLANT & NEW PLANT  ARE SAME FROM DIRECT SALE"]

{"sheet":"STOCK POINT PRICE","index":4,"n_rows":85,"n_cols":13,"rows_kept":85,"cut":false,"hidden":false,"merged":[[44,6,44,7],[1,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,10],[5,0,5,10]]}
[]
["UNITED BROTHERS"]
["CONSIGNMENT STOCKIST OF GAIL (INDIA) LTD"]
["301,HERITAGE PLAZA, R.S.MAHARAJ MARG,( TELI GALLI CROSS LANE), ANDHERI (E), MUMBAI - 400 069"]
["               TEL:  26844612(4 LINES) FAX: 26822914  E-MAIL:info@unibrothers.com,prashant@unibrothers.com,jyoti@unibrothers.com"]
["PRICE OF HDPE \"G-LEX / G-LENE \" W.E.F 1ST MAY  2014"]
[]
[null,null,"DAMAN","BHIWANDI","PUNE"]
[null,null,"ST.PT.","ST.PT.","ST.PT.",null,"   FREIGHT"]
[null,"BM",null,null,null,null,"ALWAR",985.53]
[null,"B52A003A",121860,121690,121800,null,"BHAVNAGAR",2024.85]
[null,"B52A003NA",121860,121690,121800,null,"BADDI",1758.96]
[null,"B63A003A",121860,121690,121800,null,"DAMAN",2048.77]
[null,"B63A003NA",121860,121690,121800,null,"SILVASSA",2061.17]
[null,"B55HM0003A",126300,126190,126330,null,"BHIWANDI",2537.23]
[null,"B55HM0003NA",126300,126190,126330,null,"JALGAON",1959.23]
[null,"B53EA0035A",122420,122250,122370,null,"NAGPUR",1624.98]
[null,"SHETG",null,null,null,null,"SANGLI",3069.18]
[null,"E45A003A",120230,120040,120220,null,"UMBERGAON",2016.35]
[null,null,null,null,null,null,"PUNE",2640.33]
[null,"EXTR",null,null,null,null,"WAI",2825.33]
[null,"E52A003A",123230,123040,123220,null,"HYDERABAD",3199.9]
[null,"E52A003NA",123230,123040,123220,null,"NASIK",2282.96]
[null,"E52U003A",124670,124470,124660,null,"AHMEDNAGAR",2446.9299999999998]
[null,"E52U003NA",124670,124470,124660,null,"ROHA",2814.81]
[null,"HM FILM",null,null,null,null,"AURANGABAD",2247.23]
[null,"F55HM0003A",120730,121190,121330,null,"TARAPUR",2610.9]
[null,"F55HM0003NA",120730,121190,121330,null,"THANE",2581.4699999999998]
[null,"IM HIGH",null,null,null,null,"SOLAPUR",2833.73]
[null,"I50A180A",117160,117130,117260,null,"BAROJRA",2507.0500000000002]
[null,null,null,null,null,null,"HOSUR",4749.82]
[null,"IM LOW",null,null,null,null,"JAMMU",2573.77]
[null,"I60A080A",118700,118520,118700,null,"NOIDA",1210.75]
[null,null,null,null,null,null,"PONDICHERRY",5162.96]
[null,"IM-L-UV",null,null,null,null,"UDMALPET",5424.7]
[null,"I60U080A",120430,120240,120420,null,"KOLHAPUR",3163.78]
[null,null,null,null,null,null,"BARODA"]
[null,"PIPE (PE80)"]
[null,"P54A001A",126030,125920,126060]
[null,"P54A001NA",126030,125920,126060]
[null,"PIPE (PE100)"]
[null,"P52A003A",128270,128170,128310]
[null,"P52A003NA",128270,128170,128310]
[null,"RAFFIA"]
[null,"W50A009A",117720,117530,117710,null,"QUANTITY DISCOUNT"]
[null,"T50A010A",117720,117530,117710]
[null,"MF",null,null,null,null,"QTY MTS","AMT"]
[null,"W55A004A",121660,121460,121650,null,">=10",300]
[null,"W55A004NA",121660,121460,121650,null,">=30",400]
[null,"W52A009A",118280,118090,118280,null,">=50",500]
[null,"W52A009NA",118280,118090,118280,null,">=100",600]
[null,"W52ASR009A",118280,118090,118280," ",">=200",700]
[null,"W52ASR009NA",118280,118090,118280,null,">=300",750]
[null,"LLDPE",null,null,null,null,">=400",800]
[null,null,null,null,null,null,">=600",900]
[null,"E36A060A",127050,126870,127050]
[]
[null,"FILM"]
[null,"F20S009A",125320,125140,125310]
[null,"F20S009OG"]
[null,"D22S010A",124200,124010,124190]
[null,"E20AN009A",123630,123450,123620]
[null,"ROTO"]
[null,"R35A042A",123660,123550,124620]
[null,"R35U042A",124620,124520,124660]
[]
[null,"* Ex Works Cash Discount (Rs.1000/-) ",null,null,null,null,null,null,null,null,null," "," "]
[null,"1.  Freight & Transportation will be extra and at buyers account, on Ex-Works sale"]
[null,"2.  The price of B Grade will be Rs.500/- PMT less than Prime Grade for Ex.Works sale and Rs.580/- P.M.T. less for Stock Point Sales."]
[null,"3.  The price of Old Plant & New Plant  are same from Direct Sale"]
[null,"4.  The price of Standardised Grade will be Rs.500/-PMT less than Prime Grade for Ex.Wks.sale and Rs.580/-P.M.T.less for St.Pt. Sales."]
[null,"5.  14 days interest free credit is applicable in lieu of this credit a Cash Discount of Rs.800/- PMT is offered in the "]
[null,"     basic price in case of Cash Payment in Ex-Works Sale."]
[null,"6.  Stock point Price is net price"]
[null,"7.  Cash/quantity Discount is not applicable for OG & PS Grade."]
[null,"8.  CST & Transportation will be charged extra  & at buyers account on Exworks sale  "]
[null,"9.  CST / Vat & Transporation will be charged extra & at buyers account  on Stock Point sale"]
[null,"10.  The prices are subject to change without any prior notice those prevailing at the time of delivery will be applicable."]
[null,"11.  C-Form is mandatory for all Ex-works Sales w.e.f.1st April'2002."]
[null,"12. Gas Authority Of India Ltd. changed to GAIL (India) Ltd. w.e.f. 1st January 2003."]
[null,"13. CST @ 2%  WILL BE APPLICABLE"]
[null,"14. Payment will be accepted through RTGS only."]
[]
[null,"JYOTI",9930945123]
[null,"ASHISH",9029914092]